Populating fields based on column and row headers

[Stla]

Hi! I am trying to populate fields based on the column and row header.

For example, the input would be: 

#	AA	BB	CC	DD
e		Y
f	Y			Y
g			Y
h		Y
i		Y
j				Y

All the blank fields are null. I would like to rename all fields marked with Y with its column and row header, so the ideal output would be: 

No.	AA	BB	CC	DD
e		BB-e
f	AA-f			DD-f
g			CC-g
h		BB-h
i		BB-i
j				DD-j

I could only think of using the formula tool and then use IF not null THEN "-[No].", however, my data has 10+ columns so I'm hoping to find a smarter way than doing it one by one. I tried the multi-field formula but couldn't really get it to work. Would really appreciate if anyone can help. Thanks a lot! 

[grossal · Accepted solution]

Hi @Stla,

here is a way to do it:

Output:

What happens:

1) Shifting columns to rows

2) Changing Data type to allow strings to be longer

3) Combining the Names if cell contains 'Y'

4) Shifting everything back

Workflow attached. Let me know what you think.

Best

Alex

[Stla]

Thank you very much! That was very helpful.