Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to remove intermittent blanks from a CSV import, without removing data in adjacent columns?

Hi all,   I'm importing a CSV which contains intermittent blanks in some columns, which don't align with blanks in other columns. Therefore in Power Query, if I remove blanks in one column it will ...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous 

Create a new blank query

copy source file path from "Table" and paste here,

then remove other columns, only keep "cl2",

remove blank rows for "cl2" column,

add index column from 1

 

Then in "Table", 

remove "cl2" column,

add index column from 1

merge queries

 

expand "cl2" column

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