Transpose columns to rows

[kulkarnivinay]

Hello Experts,

I have data in the below format 

ID	Name	qtr_begin_amt	qtr_end_amt	yr_begin_amt	yr_end_amt	qtr_tran	yr_tran
123	ABC	25	50	25	100	10	20

and I would like it to be in this format -

ID	Name	Period	begin_amt	end_amt	Tran
123	ABC	Qtr	25	50	10
123	ABC	Year	25	100	20

Can someone please help.

Thanks

[AngelosPachis]

Hi @kulkarnivinay ,

That should do it

I transposed to get all column headers in a single column, which allowed me to edit the names and flag if that column refers to a year or quarter.

Hope that helps,

Cheers,

Angelos

[Qiu]

@kulkarnivinay 

Here

[Emil_Kos]

Hi @kulkarnivinay,

Alternative solution:

The output:

It is funny. Each of us @Qiu @AngelosPachis took different approach 🙂

[Qiu]

@kulkarnivinay 

You can have feast now😁

[AngelosPachis]

The magic of Alteryx!