Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy solution.
I used a dynamic tool to be as dynamic as possible.
But at column "clientid" and "clienttimeprop" , there are not dynamically to cleaning.
It is important to divide the fields at splitting to row.
Hi,
My solution attached. I know nothing about macros yet, so I tried tackling this using basic tools. Current setup allows for the 20 extra columns to be processed (if they appear) and this number can be increased if needed.
Not so difficult
Good