Forum Discussion
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.
how do I either separate them completely or some how merge them together. Both options would be desirable just as a learning opportunity for me.
sorry if I did a poor job explain this
thank you in advance
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
3 Replies
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
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
Sure, no problem.
Just remember to @ mention me so I see the notice. Type @ then my name.
regards
Phil
