Forum Discussion
Help With Dividing Column by Row number
Hello, I uploaded a PDF to Power BI. The PDF is not formatted well, so neither is the pbix. I am looking to seperate everything into two rows: headers and columns. After transposing the data, mos...
Hi Anonymous ,
I create a sample to implement it in Power Query that you can have a try.
- pivot column
- unpivot columns
- remove columns
- remove alternate rows
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
I create a sample to implement it in Power Query that you can have a try.
- pivot column
- unpivot columns
- remove columns
- remove alternate rows
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.