PowerQuery Fixing the CSV broken line (Line moved to next line).

countryfan_nt

Well-known Member
Joined
May 19, 2004
Messages
716
Hello friends, Hope all is well!

I am using PowerQuery to extract combine CSV files. The Clinic name is showing error.
Because after the word Nutrition a new line is placed, the line shouldn't brake, instead it should be: Nutrition",1,160 ... etc

Can you please guide me what I can do on PowerQuery to fix the line, and stop the Error Message.


Capture.JPG


Thank you so much in advance!
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Watch MrExcel Video

Forum statistics

Threads
1,113,823
Messages
5,544,534
Members
410,617
Latest member
niayuliawati
Top