Excel - Sorting 4 columns

Closed
sjk - Dec 16, 2008 at 08:27 PM
zebraal Posts 11 Registration date Tuesday September 16, 2008 Status Member Last seen April 16, 2009 - Dec 17, 2008 at 12:55 AM
Hello,
I need some help with the data I have gathered from a form with a question with a multiple tick option.
The data collected is similar to this:

March, May, June, July, December
February, August
February, June
April, September, October


I've used text to column to sort the data to a cell in new columns:

Col1 Col2 Col3 Col4 Col5
March May June July December
February August
February June
April September October

Am I able to use macro to sort out each field to look like this:

Col1 Col2 Col3 Col4 Col5
March May June July December
February August
February June
April September October


Hope someone can help me...

Cheers
Sharon

1 reply

zebraal Posts 11 Registration date Tuesday September 16, 2008 Status Member Last seen April 16, 2009
Dec 17, 2008 at 12:55 AM
Hi,

Well your question was not evry clear but I think that this link can help you out https://support.microsoft.com/en-us/help/247311

Good Luck!
0