Forum Discussion
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...
Hi SergeiBaklan
Thank you very much!
I followed your steps to change the information and tried it. I have succeeded! But I made a mistake in my question.
The value contained in the 'Number' column should be ‘123456’ instead of ‘a123’. After replacing the ‘number’ with ‘letter + number’ in my table , I succeeded.
Do you know how to modify the step if the number column is all numeric?
Victoria-9 , in addition I added months sorting by adding month number in front of each its name before pivoting; removed that index on latest steps.