Calculation between rows with same ID

[BInovice]

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. 

ID	Attribute	Value	Cal=(A+C+D)/B
ID1	A	6
ID1	B	2
ID1	C	3
ID1	D	1	5
ID2	A	100
ID2	B	40
ID2	C	56
ID2	D	89	6.125

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

ID	A	B	C	D	Cal=(A+C+D)/B
ID1	6	2	3	1	5
ID2	100	40	56	89	6.125

Any helps are greatly appreciated.

[AlexisOlson · Accepted solution]

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

Then Add Column > Custom Column

[BInovice]

Thank you @AlexisOlson . The solution works magic