Forum Discussion
Merge cells
Hello All,
I have a source from pdf as below. Names/data splitted in two rows instead of in a cell( single row). The final output should be in a single row by merging first two rows as a single row ( null should go and data should add) and the third row should come as column ( with header as ' other staff' and under that ' Evan molly'. Thankful if any one could give step by step procedure of power query editor.
Hi Rak14 ,
There is usually no easy way, probably because the data in your PDF is not a table.
There're two videos for your reference.
[Power BI] How to Clean and Transform MESSY Data using Power Query in Power BI
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Rak14 ,
There is usually no easy way, probably because the data in your PDF is not a table.
There're two videos for your reference.
[Power BI] How to Clean and Transform MESSY Data using Power Query in Power BI
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.