Excel Text to Column for Multiple Column [Closed]

Report
Posts
16
Registration date
Tuesday June 1, 2010
Status
Member
Last seen
July 11, 2012
-
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!