Hello: need help with transposing data from Column to rows for example: From: CountryDiscount CodeNew Product GroupOld Product name 1Old Product name 2Old Product name 3Old Product name 4Old Product name 5AA11426429430431432433AA11428456456456456456AA11429465465465465465 To: CountryDiscount CodeNew Product GroupOld Product name AA11426429 AA11426430 AA11426431 AA11426432 AA11426433 AA11428456 AA11428456 AA11428456 AA11428456 AA11428456 AA11429465 AA11429465 AA11429465 AA11429465 AA11429465

Transpose data

Hello:

need help with transposing data from Column to rows

for example:

Developer

Thank you!!

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.

Thank you!!

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