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 ...
Yes, with gaps in there when done with columns 1 and 3. I'm trying to create a table with no gaps between fields
Ashish_Mathur
Super User
Super UserHi,
Once you fill the gaps in column 2 (as described above) and drag that column to the visual, you will not face any problem.