Move Data from Columns to Rows with New Headers

Question

I've been trying to move data from columns into rows with a new header for the rows. I have already figured out one way, however my method will work fine so far as the number of IDs are limited, thus if you look at my output I miss ID 4 & ID 5 for State 1 and so on.

Is there any way to modify this workflow to be dynamic and allow for it to increase the number of row headers based on the data?

The input and output data should look as shown below. I have also attached the workflow I've built which gets me this result.

Input

Current Output

Desired Output

Transpose_Column_to_Rows.yxmd

JosephSerpis · Accepted Answer

Hi @utpal_kowshik I mocked up a workflow let me know what you think?

grazitti_sapna · Accepted Answer

Hi @utpal_kowshik , is this what you were looking for?

Thanks.

RolandSchubert · Accepted Answer

Hi @utpal_kowshik ,

I've used a different approach - what do you think?

I've attached a sample workflow. Let me know if it works for you.

Best,

Roland