Transpose Multiple Columns

[chc10]

Hi

I'm trying to pull apart some data from multiple columns and transpose it to rows.

As Is

DATE	CATEGORY	PURCHASE_VOLUME_4W	PURCHASE_VOLUME_12W	PURCHASE_VOLUME_52W	PURCHASE_VALUE_4W	PURCHASE_VALUE_12W	PURCHASE_VALUE_52W
11/20/2020	COLOGNE	15142	34161	174355	111730	242573	1264613
11/20/2020	COLOGNE	10387	37116	249886	73596	262819	1764439

To Be

DATE	CATEGORY	PERIOD_GROUP	PURCHASE_VOLUME	PURCHASE_VALUE
11/20/2020	COLOGNE	4W
11/20/2020	COLOGNE	4W
11/20/2020	COLOGNE	12W
11/20/2020	COLOGNE	12W
11/20/2020	COLOGNE	52W
11/20/2020	COLOGNE	52W

Pls can you help?

Thanks

[Qiu]

@chc10 

Can you explain the significance of Two repeated Period Time. I summaried them as of now.

[AkimasaKajitani]

Hi @chc10 

I make workflow.

Please refer attached file.

I use the newest Designer version 2020.4.

If you can't open the attached file, you have to update designer or version down the yxmd file(open by text editor and overwrite version info).

[T_Willins]

Hi @chc10,

This should work for your data set.  By using key columns in the Transpose tool and group by data in the Cross Tab you can get the data into the format you are looking for.  The RecordID tool at the beginning keeps each line separate for the Cross Tab tool.

[DeanWest]

Here is a proposed solution 😊

[grazitti_sapna]

Hi @chc10,

Here is my take on this problem.

I hope it helps.