Transpose?

[vivian123]

I have a huge dataset. My table looks something like the input table but am wanting it to look like the output table. How can I do this? Thanks!

[mceleavey]

Hi  @vivian123 ,

Can you please post some data rather than a screenshot so we can help you?

M.

[Emil_Kos · Accepted solution]

Hi @vivian123,

Please find the workflow below:

Please find the output below:

For the future please be so kind to put the data inside of your question as @mceleavey suggested. Thanks to that it is easier to prepare a solution for you. 

[vivian123]

Thank you! this worked great