Transformation using Power Query Editor for making the data tables leaner

[psrijith]

Hi Friends,

I want to transform the below table  in POWER Query : 

Date	ABC	DEF	GHI	JKL	MNO
Jun-1981	2608351	1958717	1178447	653940	657249
Sep-1981	2616060	1964139	1189946	655136	663047
Dec-1981	2624579	1969349	1200504	657014	667381
Mar-1982	2634534	1975617	1210128	658840	672273

into :

SID	Date	Volume
ABC	Jun-1981	2608351
DEF	Jun-1981	1958717
GHI	Jun-1981	1178447
JKL	Jun-1981	653940
MNO	Jun-1981	657249
ABC	Sep-1981	2616060
DEF	Sep-1981	1964139
GHI	Sep-1981	1189946
JKL	Sep-1981	655136
MNO	Sep-1981	663047
ABC	Dec-1981	2624579
DEF	Dec-1981	1969349
GHI	Dec-1981	1200504
JKL	Dec-1981	657014
MNO	Dec-1981	667381
ABC	Mar-1982	2634534
DEF	Mar-1982	1975617
GHI	Mar-1982	1210128
JKL	Mar-1982	658840
MNO	Mar-1982	672273

The idea is to make the data struture leaner i.e. less number of columns in the data tables.

Please suggest the exact steps that need to be performed to optimally achieve the above using power query.

Regards,

Srijith

[mahoneypat · Accepted solution]

In the query editor, select your Date column, then right click on the header and choose "Unpivot Other Columns".

Pat