Transform Tool - Columns to Rows

[AmAm]

Hi All,

So I have a set of data that is vertically and I want to shift it to become horizontally. But I don't know how. Can someone show me how it is done? 

Thank you in advance,,

Before,

After,

[IraWatt]

Hey @AmAm,

This could probably be made into a macro but this is the easies say I found of achieving this: 

[fharper]

Here is an alternative that takes advantage of Cross Tab and Field Sort and Dynamic Rename....Almost always more than one way to solve a problem.

I apologize that I could not upload the flow, there seems to be some issue today doing that, maybe a new security policy here...

[IraWatt]

ah nice @fharper, couldn't figure out how to do that with the cross tab! Much better solution by the looks of it :D

[fharper]

@AmAm , I think the solution @IraWatt provided or my own would be good solutions but I see you have not flagged either.  it is helpful to all if you would mark someone's contribution as a solution if it satisfies your needs and if not maybe provide more context so someone can help you further.  Everyone searches the community for solutions at times and many seek to help provide solutions and that only works when the original thread owner identifies a response as a solution.  

[flying008]

Hi, @AmAm 

There is another dynamic solution for the case.

[grazitti_sapna]

Hi @AmAm, another solution to the problem. I hope this helps!

Thanks!