Transpose column of Data

[sriku]

Hi All,

I need help in transpose column of data to Catergory and sub-category format as mentioned :

Unique	Month	Category	Sub_category	Amount
20	12/1/2015	Category_1	Sub_category1	310
31	12/1/2015	Category_1	Sub_category2	278
35	12/1/2015	Category_1	Sub_category3	176
97	12/1/2015	Category_2	Sub-Category1	212
98	12/1/2015	Category_2	Sub-Category2	170
99	12/1/2015	Category_2	Sub-Category3	250
108	12/1/2015	Category_2	Sub-Category4	110
161	12/1/2015	Category_2	Sub-Category5	366

Thanks,

Srikant

[RolandSchubert]

Hi @sriku ,

just to clarify - if you transpose the first row in your sample data using category and sub-category as row labels, you will end up with 8 rows (one row for each sub-category, grouped by two categories). In your result, there is only one row. Is there any additional rule or transformation needed?

Best,

Roland

[RWvanLeeuwen]

Hi @sriku ,

Is this what you need?
I noticed the colours in the excel so I treated the subcategories as nested within the categories

Best,

Roland

Infotopics - Benelux partner of the year

Empowering business through analytics. See, Understand, Act!

[RolandSchubert · Accepted solution]

Without any additional rules, the result would be:

See attached worklfow.