Forum Discussion

User_Error's avatar
User_Error
Regular Visitor
5 years ago
Solved

Imported PDF file formatting

I have data in a column I’m my PDF file that looks like this $12.00 - $14.00 When I import the pdf the column gets separated for some of the cells and places the values in two separate columns.   ...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi User_Error 

    To merge them, in Power Query select both columns then right click one of the column headers and choose Merge Columns.

     

    Choose settings like this

     

    This is the result

    Regards

    Phil

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi User_Error 

To merge them, in Power Query select both columns then right click one of the column headers and choose Merge Columns.

 

Choose settings like this

 

This is the result

Regards

Phil

User_Error's avatar
User_Error
Regular Visitor
5 years ago

Thank you Phil this was a great help.  I also figured out the split column using a delimiter to separate the data in this as well.  I really appreciate your assistance look forward to asking you many more questions LOL.  I have one regarding the map visualization and the count of people by Zip Code.  I'll have to post it and Tag you if your available  

 

 
 

 

 

 

 

 

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    5 years ago

    User_Error 

    Sure, no problem.

    Just remember to @ mention me so I see the notice.  Type @ then my name.

    regards

    Phil