Calculation between rows with same ID

Question

All, my data are structured as below and I need to run the calculated values in the last column. Each ID contains exact same 4 attributes.

Alternatively a way to unpivot the table to the following would do, but I could not quite figure it out.

Any helps are greatly appreciated.

alexisolson · Accepted Answer

You can easily unpivot in the query editor. Select the Attribute column and under the Transform tab, choose Pivot column.

Then Add Column &gt; Custom Column

&nbsp;

Forum Discussion