Forum Discussion
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 ...
v-juanli-msft
Community Support
Community SupportHi Anonymous
Create a new blank query,
copy the source file path and paste here,
keep only "cl2" column,
remove blank row for "cl2" column,
add an index column from 1
in Table, remove "cl2" column,
add an index column from 1,
merge queries, expand "cl2" column
Best Regards
Maggie
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.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.