Excel Text to Column for Multiple Column

Closed
j3kj3k Posts 16 Registration date Tuesday June 1, 2010 Status Member Last seen July 11, 2012 - Jul 11, 2012 at 06:16 PM
Hello,

I need help on a task envolve with Text to Column.
Below is example. select all / copy / paste on excel spread sheet, you will see it better view. or let me know the email address I can send the excel file.

Thanks in advance
J3K



Input File (file can have hundreds of rows)

Name Gender First Name Middle Name Last Name Fruits Animals Automobile Vegetables Home
John C. Doe Male John C. Doe Apple,Orange,Banana,Grape Dog,Cat Bicycle Yes
Jane Role Doe Female Jane Role Doe Cat Potato,Cabage Yes
Kim Johns Female Kim Johns Grape,Apple Cat,Fish Cabage Yes
C. W. Elliot Male C. W. Elliot Banana Bicycle,Car,Moped Yes


Result

Name Gender First Name Middle Name Last Name Fruits Animals Automobile Vegetables Home
John C. Doe Male John C. Doe Apple Dog Bicycle Yes
Orang Cat
Banana
Grape
Jane Role Doe Female Jane Role Doe Cat Potato Yes
Cabage
Kim Johns Female Kim Johns Grape Cat Cabage Yes
Apple Fish
C. W. Elliot Male C. W. Elliot Banana Bicycle Yes
Car
Moped