Forum Discussion
Power BI Data Transformation Question
Anonymous in this case, you will have to unpivot and pivot your data. below is the sequence that you can follow
1. Your data is in below format. Open your data in power query window
2. then select the last 4 columns of your data and then go to unpivot columns and select unpivot only selected columns. Your data will transform into below format
3. now you can split column2 basis space delimiter, your data will be in below format
4. last option now you need to pivot the data back, select last two columns and choose pivot column option. your data will be converted into below format which you need here
for your reference, i am attaching the pbix sample file which you can use to go step by step. let me know if it helps you. thanks
Anonymous in this case, you will have to unpivot and pivot your data. below is the sequence that you can follow
1. Your data is in below format. Open your data in power query window
2. then select the last 4 columns of your data and then go to unpivot columns and select unpivot only selected columns. Your data will transform into below format
3. now you can split column2 basis space delimiter, your data will be in below format
4. last option now you need to pivot the data back, select last two columns and choose pivot column option. your data will be converted into below format which you need here
for your reference, i am attaching the pbix sample file which you can use to go step by step. let me know if it helps you. thanks
Thank you very much for your help. It works perfectly!