Hi ! I Need help creating a table using pivot (I guess)

[Anonymous]

Hi there, i need some help creating a table.

I have data in tabular way, as shows in picture 1, and i need to create a overview table with a deviation column like i show in second picture

Is any way to create this ? i guess it might work with double pivoting? but i'm not sure.

Please help 😄 thank you very much

[Anonymous]

Thank you a lot for your detailed expression, i'll try it right away!

[Anonymous · Accepted solution]

Hi @Anonymous ,

You need to unpivot columns first, then spilit an attribute column by space, and then pivot again.

Detailed steps:

1.Select the four columns and click "Unpivot Columns".

2.Split by space.

3.Select the Attribute.1 column and then click "Pivot Column".

4.Set up as follows and click OK.

Final result is as follows. It's displayed as a matrix visual.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.