Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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
Proud to be a Super User!
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
Proud to be a Super User!
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
Proud to be a Super User!