Transposing multiple columns for every 8 rows

[MK2302]

Good day everyone,

I am currently trying to work with a client data export from a PowerBI source.

The data is in the following format: 

Column 1: Identifier

Column 2: Table header

Column 3: values

Column 4: Table header

Column 5: values

The identifier is always the same for 8 rows such that Columns 2-5 contain different values for 8 rows per 1 identifier. 

I am trying to transform this data such that 

- there is only one row per identifier with 9 columns: 1 identifier and then 8 values

- columns 2 & 4 can become the column names

Does anyone have input on how to best approach this?

[aatalai · Accepted solution]

@MK2302 can you upload expected input and output? dummy data is fine

[MK2302]

Thanks a lot! I did figure it out in the meantime with a mix of transpose, multi-row formula and summarizing. Thanks anyways for picking it up!