Hi,
I have repeat job each month that could do with some automation. There are c1500 records (in excel) each having a unique value in column A and change each month and there is no sequence, I need to concatenate these into a field separated by "," every 90 records. I thought this could be more a Access job than excel.
I don't have this is in a DB yet but basically trying to work out what is the best route for this?
Existing
Ouput
Many Thanks
I have repeat job each month that could do with some automation. There are c1500 records (in excel) each having a unique value in column A and change each month and there is no sequence, I need to concatenate these into a field separated by "," every 90 records. I thought this could be more a Access job than excel.
I don't have this is in a DB yet but basically trying to work out what is the best route for this?
Existing
Reference | |
10001 | |
10002 | |
10003 |
Ouput
Reference | |
10001,10002,10003... | Up to 90 records |
10091,10092,10093... | Next 90 records |
Etc | |
Etc |
Many Thanks