I need to convert 8 columns into rows and keep an ID column repeating for the converted columns

[wkurten]

Hi folks!

I have this table:

And i need it should be transformed in a structure like this:

Basicly transforming theme columns to rows while keep the number column repeated on all theme rows

I've tried to do this using basic transformations but i'm not able to achieve this, i think that only could be done with some formulas. but i dont know how.

[Omid_Motamedise · Accepted solution]

Right click on the column Number, and select Unpivot other columns (Or select all the 8 columns, right click on one of them and pick unpivot columns)

[wkurten]

worked perfectly! thanks Sir!

result:

[wini_R]

Hey @wkurten,

It seems you need to unpivot your table - just right-click the 'number' column and select 'Unpivot other columns'. Then you may need to remove an additional 'Attribute' column