Forum Discussion
Solved
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 ...
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.
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.