Names/data splitted in two rows instead of in a cell( single row)

[Rak14]

Hi,

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. 

[v-yalanwu-msft]

Hi, @Rak14 ;

Is your problem solved?  If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @Rak14 ;

I think you can try it, first use third-party software to convert pdf to excel, and then power bi to get excel's data source, after all, power bi is a set of data processing, data model, data visualization as one of the software; There will be cases where pdf recognition is out of order, so consider using other third-party tools, such as the following, or others.

PDF to Excel Converter Try Free Download Now - V3 | PDF2XL

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.