Hi Masters!
I'm in dire need of your help!
I have a messy file filled with data that I need to clean up. The data is roughly like this :
And I need the end product to be like this :
So that I could start washing the data.
Most of the data would be as per Row 1 and 2 where they are separated by Enter in the same cell. So if you could help me with that alone, that would be more than great!
Also, the characteristic of the Name in Column B is that they are 10-digit codes.
Please let me know if there's any info you need!
Thanks in advance! I really appreciate your help!
I'm in dire need of your help!
I have a messy file filled with data that I need to clean up. The data is roughly like this :
sample.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Code | Name | Details | ||
2 | AA1 | Person 1 Person 2 Person 3 | Person 1 Address Person 1 Phone Person 1 Email Person 2 Address Person 2 Phone Person 2 Email Person 3 Address Person 3 Phone Person 3 Email | ||
3 | AA2 | Person 4 Person 5 | Person 4 Address Person 4 Phone Person 4 Email Person 5 Address Person 5 Phone Person 5 Email | ||
4 | AA3 | Person 6, Person 7 | Person 6 Address Person 6 Phone Person 6 Email Person 7 Address Person 7 Phone Person 7 Email | ||
Sheet1 |
And I need the end product to be like this :
Code | Name | Address | Phone | |
AA1 | Person 1 | Person 1 Address | Person 1 Phone | Person 1 Email |
AA1 | Person 2 | Person 2 Address | Person 2 Phone | Person 2 Email |
AA1 | Person 3 | Person 3 Address | Person 3 Phone | Person 3 Email |
AA2 | Person 4 | Person 4 Address | Person 4 Phone | Person 4 Email |
AA2 | Person 5 | Person 5 Address | Person 5 Phone | Person 5 Email |
AA3 | Person 6 | Person 6 Address | Person 6 Phone | Person 6 Email |
AA3 | Person 7 | Person 7 Address | Person 7 Phone | Person 7 Email |
So that I could start washing the data.
Most of the data would be as per Row 1 and 2 where they are separated by Enter in the same cell. So if you could help me with that alone, that would be more than great!
Also, the characteristic of the Name in Column B is that they are 10-digit codes.
Please let me know if there's any info you need!
Thanks in advance! I really appreciate your help!