Need Help! Data transformation

[Anonymous]

Hi,

Could anyone please help me to transform data in desired output in Power BI.

Input Data

ID	COL1	COL1_Value	COL2	COL2_Value	COL3	COL3_Value
1	ServerName	ABCDEF	ServerName	POIUYT	ServerName	QWERTY
2	DiskName	D	DiskName	E	DiskName	F
3	Application	LKJ	Application	HYU	null	null

Output:

ID	ServerName	DiskName	Application
1	ABCDEF	D	LKJ
2	POIUYT	E	HYU
3	QWERTY	F	null

Thanks,

Randhir