Transpose without repeated values

Question

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!

excel 1.xlsx

aatalai · Answer

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

Shannon11113 · Answer

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 · Answer

@Shannon11113 based on my understanding this should work

Transpose without repeated values.yxmd