Transposing Headers

[Arunima_S]

Hi,

I am trying to transpose 3 headers into 3 different columns. 

My input looks like this:

		Category 1			Category 2			Category 3
		Sub-Cate 1	Sub-Cate 2	Sub-Cate 3	Sub-Cate 1	Sub-Cate 2	Sub-Cate 3	Sub-Cate 1	Sub-Cate 2	Sub-Cate 3
Month	Year	Net Amt	Net Amt	Net Amt	Net Amt	Net Amt	Net Amt	Net Amt	Net Amt	Net Amt

I want to transpose the Category, Sub Category and Net amount field as:

Month	Year	Category	Sub-Cate	Net Amt
Jan	2000	Category 1	Sub- Cate 1	Net Amt
Feb	2000	Category 1	Sub- Cate 2	Net Amt
Mar	2000	Category 1	Sub- Cate 3	Net Amt
Apr	2000	Category 2	Sub- Cate 1	Net Amt
May	2000	Category 2	Sub- Cate 2	Net Amt
Jun	2000	Category 2	Sub- Cate 3	Net Amt
Jul	2000	Category 3	Sub- Cate 1	Net Amt
Aug	2000	Category 3	Sub- Cate 2	Net Amt
Sep	2000	Category 3	Sub- Cate 3	Net Amt

Is there a way to transpose them all at the same time?

Appreciate your help!

Thank you

[AbhilashR · Accepted solution]

Hi @Arunima_S, I have put together a sample workflow that helps transform your dataset. The output is similar to what you are looking for but not exact. The raw data didn't have month/year values so for now, I have kept month/year as placeholder text. But the approach should work on your actual dataset.

Hope this helps!

[Arunima_S]

Worked like a charm! Thanks @AbhilashR 

[Inactive User]

Just what i was looking for. Thanks for this great answer.