How to Transpose Data from Horizontal to Vertical in Alteryx?"

[Masond3]

Hi Team,

I have data in a horizontal format  ( 3 columns and roughly 11 rows per file name) and need to transpose it to a vertical format. Could you please guide me on how to achieve this?

Data input 

Event	Unique	File Name
Sent	402	Testing Mkting
Delivered	400	Testing Mkting

Desired output 

File Name	Sent	Delivered
Testing Mkting	402	400

[alexnajm · Accepted solution]

Cross Tab tool is your answer! File Name as the group, Event as your header, Unique as your value, and likely just Sum/Concatenate as your aggregation

[Masond3]

@alexnajm  - So i assume, i group data by filename ? 
Headers be event ?  , values = Unique 
Aggregating values = First ? 

[alexnajm]

Everything like I said yes - the aggregation is the only thing that's your choice