When I import my XML to Excel 2003, the format is wrong.
Current format:
NAME | AGE | CUSTOM
bob | 24 | male
bob | 24 | cheese
bob | 24 | music
john | 30 | male
john | 30 | ham
john | 30 | sports
Desired Format:
NAME | AGE | GENDER | FOOD | HOBBY
bob | 24 | male | cheese | music
john | 30 | male | ham | sports
I did not play with it, I just imported it using 'Import XML' and let excel format it automatically.
How can I split up that CUSTOM column?
Bookmarks