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

Question

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 · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
You need to unpivot columns&nbsp;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.

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

&nbsp;
&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;