Forum Discussion

Victoria-9's avatar
Victoria-9
Copper Contributor
Mar 19, 2019

Data model conversion-Power Query

Hello,all. I have encountered a problem, as shown in the photo.   I got some data (Figure 1) and want to convert it to the form of Figure 2.I have entered Power Query through the From Tableļ¼ˆFigure...
excel
power bi
Victoria-9's avatar
Victoria-9
Copper Contributor
Mar 20, 2019

PeterBartholomew1 

Thanks for the way you provide, I will try it. Before, I saw a way to process this data using PQ in the same table, perhaps changing the title form, but I forgot,I will continue to look for.

Thanks very much for your help.

PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Mar 20, 2019

Victoria-9 

I think I have found A way of doing what you want without splitting the table into two.  I won't claim it is THE way because I am just working by trial and error!

If you create single level headers by manually concatenating the J/K with the month (a space will do as a separator) and then unpivot, you get a table twice as long as you want.  If you then split the compound column into its letter and date parts, you can (re)pivot on the new letter column to give the J and K output in separate columns.

I am not sure whether this helps you but I am learning!

Resources