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?