Transpose Data and Concatenate

[esjohnston]

Hello, 

I have data that has the monthly amounts of each account in columns. I would like to transpose them to rows. The year is in a separate column, and I would like to concatenate it to the transposed 'month' rows. 

Please see original vs desired data in attachment. 

[clmc9601]

Hi @esjohnston,

I believe this workflow matches your desired output. I hope it helps! 

The sample and dynamic rename tools are specific to this excel sheet and probably won't be necessary with your real data. 

[AbhilashR]

Hi @esjohnston, I have included an alternate attempt in my post here. The workflow attempts to be flexible to accommodate more than two date values that may flow through in your source data, i.e. if you have more than two dates, the Transpose tool with transpose the dates for us.  

I hope this helps.