Transpose without repeated values

[Shannon11113]

Hi Community! I am having difficulty with this issue. I have transposed all my column headers into a single column, i would like the Entity data to be repeated but the value should correspond to the data that i have originally. I have attached sample data to display the input that i have and the output that i want. Thank you! 

[ed_hayter]

Not sure I understand the problem - I have replicated the desired output and hopefully it gets the ball rolling and someone else might be able to get this over the line.

[Shannon11113]

hey @ed_hayter . Thank you so much for ur help! However, im looking for something more dynamic as the entity names will change in the future. 

Also i realized i made a mistake in my excel file sorry. below is the new file 

[cjaneczko]

Not following the desired output. Columns K-N are not in your desired output and there is no relation in column O to each of the Entities. If you are just looking to repeat the data in column O for each entity, you only need to use an Append Tool and not include columns K-N. 

[aatalai]

@Shannon11113 based on my understanding this should work

[Shannon11113]

hey @aatalai thanks for your help! i finally got the right structure that i wanted. bt in my actual data, the values do not correspond to my entity name. instead its showing values frm 3 column backwards… do you know how to solve this? thanks!

[aatalai]

@Shannon11113 is it please possible to have some dummy data/screenshot/workflow uploaded?