Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere's my solution.
Please find attached. I went with a macro that passes through the number of columns found in the starting data, and then updates a Text to Columns tool based on the total.
Data cleanse takes out the rows of ----'s and a quick formula to standardise ClientID