Need Help! Data transformation

Anonymous

Not applicable

7 years ago

Thanks for your time and efforts. This is what I am looking for a dynamic approach. Actually I have total total 40 columns ( COL1,COL_Value, COL2,COL2_Value.... COL20, COL20_Value) .

Your solution is working fine as per sample data posted on web.

But still I am not able to understand how TABLE4 works.

It would be really great if you can explain me working of TABLE4.

Sorry,I am new to Power BI, could you please consider the table below as your Excel source and provide me query.

I'll modify your query for others remaining columns and try at my real data. Please note, given below sample data is containing all the possible scenerios.

ID	COL1	COL1_Value	COL2	COL2_Value	COL3	COL3_Value	COL4	COL4_Value	COL5	COL5_Value
1	ServerType	str6val	Application	str12val	Metric	str18val	Perimeter	str22val	SubServerType	str1val
2	ServerType	str7val	ServerType	str13val	Metric	str19val	Perimeter	str23val	SubServerType	str2val
3	ServerName	str8val	ServerName	str14val	Application	str20val	Metric	str24val	SubServerType	str3val
4	ServerName	str9val	ServerName	str15val	ServerType	str21val	Application	str25val	Perimeter	str4val
5	ServerName	str10val	ServerName	str16val					Metric	str5val
6	DiskName	str11val	ServerName	str17val					Metric	str6val

Thanks,

Randhir

Forum Discussion

Related content

Urgent Help - Power Query - Data Transformation

Table Transformation

Transform columns / type

Data transform using power query

Table Transformation