Forum Discussion

MUHAMMAD_TARIQ's avatar
MUHAMMAD_TARIQ
New Member
4 years ago

While importing from text file by Power Query Editor in Excel some column values go to next column

4 Replies

  • check for tabs (\t) inside your data.  Provide a sample text file if you like more help.

  • Thank you so much Ibendlin for replying. I am  attaching sample file below for your reference. Yellow circle indidates error caused by sliding of column value to next column:

     

     

    • lbendlin's avatar
      lbendlin
      Super User

      try attaching again/post it on a file share.