Hi All, I need help in transpose column of data to Catergory and sub-category format as mentioned : UniqueMonthCategorySub_categoryAmount2012/1/2015Category_1Sub_category13103112/1/2015Category_1Sub_category22783512/1/2015Category_1Sub_category31769712/1/2015Category_2Sub-Category12129812/1/2015Category_2Sub-Category21709912/1/2015Category_2Sub-Category325010812/1/2015Category_2Sub-Category411016112/1/2015Category_2Sub-Category5366 Thanks, Srikant Dummy Data.xlsx

Transpose column of Data

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

Dummy Data.xlsx

Dynamic Processing

Accepted answers

RolandSchubert

Without any additional rules, the result would be:

See attached worklfow.

Organize_Transpose.yxmd

All comments

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?