Merge cells

[Rak14]

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. 

[Anonymous · Accepted solution]

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.

How to Clean 🧹 Messy Data using Power BI Query Editor? Example: Clean Names with Comma, Dash, Space

[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.