Transpose Data and Concatenate

Question

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.

Alteryx Example Data.xlsx

AbhilashR · Answer

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.

sample.yxmd

clmc9601 · Answer

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.

Transpose_esjohnston.yxzp