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
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

I suggest that you plug in the blank cells with the value appearing from above.  Right click on the second column's heading and select Fill > Down.

Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Hi, thanks for that suggestion - I probably should have mentioned that I want to put this information in a table, so don't want duplicates showing.
    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      6 years ago

      Hi,

      When you drag column 2 to a Table visual, you will only see unique entries.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago
        Yes, with gaps in there when done with columns 1 and 3. I'm trying to create a table with no gaps between fields