Transpose Multiple Column and add new column

[Abhishek_Gupta]

Hi 

I have a table containing data for multiple periods. My task is to transpose the period data into rows and add a new column which defines what period data is it. Below is the example for the same.

Input Table

Category	Brand	Revenue 13 Week	Qty 13 Week	Revenue 26 Week	Qty 26 Week
C1	B1	33.2	34	45	46
C1	B2	23	20	40.3	34

Output Table

Category	Brand	Revenue	Qty	Period
C1	B1	33.2	34	13 Weeks
C1	B2	23	20	13 Weeks
C1	B1	45	46	26 Weeks
C1	B2	40.3	34	26 Weeks

Can anyone please suggest if this is even possible in Alteryx?

[MSalvage · Accepted solution]

@Abhishek_Gupta,

Definitely possible. I have attached a workflow that gets this done. Might have to fiddle with the Regex for your real data.

Hope this helps,

Msalvage

[Abhishek_Gupta]

Wowww..Thats a cool solution...some minor tweaks were required to fit in my actual data...Thank you very much