I have an access database I need data formatted from. There
is a column in the database with multiple strings concatenated together, I
need them split up and then appended to a new row with the values from the
row.
For example, the row may read Zztest,Joshua 01/01/1970
00001000020000300004. I need the 00001 broke out into a unique row with the
preceding values, the value in that column will always have the same number
of characters. That row need to be exported as:
Zztest,Joshua 01/01/1970 00001
Zztest,Joshua 01/01/1970 00002
Zztest,Joshua 01/01/1970 00003
Zztest,Joshua 01/01/1970 00004
Any help would be greatly appreciated.
Thanks,
Will