Good morning all, I receive a file every month as per the attached. It is basically a big list of car park transactions for a number of car parks. I can get most of the cleaning up done myself but I'm struggling to remove the groups by car park. How can I add in a column at the left and then fill down taking into account the pagination? Or do I remove the pagination before doing the fill down? Because the pages are not all of a consistent length, I can't work out the logic. All help appreciated. Best regards
Hi Richard,
Welcome to our forum!
Add a custom column that checks if column B is empty. If it is, bring in the car park name, otherwise return null. Then you can Fill Down the car park name, then remove rows that are empty from column B.
Hope that points you in the right direction.
Mynda