Transform a table

[llchoong]

Hi Community members, I would like some help with transforming the table on the left to the table on the right. Your help is very much appreciated.

TEST DATA.xlsx (13.5 KB)

[Melissa]

Hi @llchoong,

Here’s a UI solution for you, just follow these steps:

1. Use headers as first row
2. Transpose table
3. Select “Column1” > Unpivot Columns > Unpivot Other Columns
4. Remove the “Attribute” column
5. Select all columns > Remove Rows > Remove Duplicates

Here’s the end result.

I hope this is helpful

[llchoong]

Thank you, this is helpful!