Aug 12 2022 09:57 AM
I've exported delivery data from a confluence table and want to have it tidied up. I was hoping to use Power Query, but as a newbie I'm struggling and I've taken far too long on attempting to figure this out without success. I'm hoping to be able to automate it so that when I get the data from a folder I've downloaded it to, it will neaten it up and put it in a little table so I can start generating cost reports.
I've anonymised the data and taken a screenshot so you can see how it shows on excel. You'll see that there are several merged and non-merged cells due to the way the addresses have been inputted.
There's about a years' worth of data on this table spanning a good few hundred rows.
How do I clean this up so they all have a single row each and each address is merged into a single cell?
Is Power Query the best way or is there a better alternative?
Aug 13 2022 01:37 AM
@Gem_M Could you share a link to the anonymized file via OneDrive or similar? That would make it much easier to come up with a PQ solution.
Aug 13 2022 02:07 AM
Power Query shall work if only having hyperlinks for Key and Summary is not critical. PQ won't return hyperlinks, only texts.
Aug 15 2022 06:41 AM
Aug 15 2022 06:42 AM