Transpose data

[chintan2171]

Hello:

need help with transposing data from Column to rows

for example:

From:
Country	Discount Code	New Product Group	Old Product name 1	Old Product name 2	Old Product name 3	Old Product name 4	Old Product name 5
AA	11	426	429	430	431	432	433
AA	11	428	456	456	456	456	456
AA	11	429	465	465	465	465	465
To:
Country	Discount Code	New Product Group	Old Product name
AA	11	426	429
AA	11	426	430
AA	11	426	431
AA	11	426	432
AA	11	426	433
AA	11	428	456
AA	11	428	456
AA	11	428	456
AA	11	428	456
AA	11	428	456
AA	11	429	465
AA	11	429	465
AA	11	429	465
AA	11	429	465
AA	11	429	465

[Luke_C]

Hi @chintan2171 

Here's how you can do this:

• Transpose tool selecting Country, Distinct Code, and New Product Group as the key columns
• Select tool to remove the auto-generated 'Name' column and rename the 'Value' column to meet your requirement.

[chintan2171 · Accepted solution]

Thank you!!

[Luke_C]

@chintan2171 Not a problem! Please remember to mark my solution so others can search for it easier in the future.