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 EventUniqueFile NameSent402Testing MktingDelivered400Testing Mkting Desired output File NameSentDelivered Testing Mkting402400

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

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

Common Use Cases

Accepted answers

alexnajm

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

All comments

alexnajm

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703