Hello Everyone,
I have an excel file I am trying to adapt to an access table. The original user has done this:
ID | PJT
1 1, 2, 3, 4
2 5
3 6, 7
4 8, 9, 10
5.. 11
I want this:
ID | PJT
1 1
1 2
1 3
1 4
2 5
3 6
3 7
4 8
4 9
4 10
5 11
Except there are over 300 IDs and some columns have over 30 PJT numbers separated by commas. They aren't sequential and each one has 6 digits.
I know how to text to columns and transpose, but that only gets me to the point where I manually have to cut and paste each into one column then I have to make sure the ID number is with the corresponding PJT. Not a fan of wasting time doing it manually when there may be an easy solution.
Any help is appreciated.
Thanks,
Matt