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
Configuration: Windows XP Internet Explorer 6.0
Hi,
|
Compare column data in excel Conditional formatting excel last cell in column Date column wont format excel Define column name, excel vba Excel 2007 formula days 1 column Excel find and replace with column break Excel how to find data in column which is not in another column Excel increase price column Excel macro insert column Excel match two columns Excel match two columns vlookup Excel sort based on column macro Excel sort range left to right then top to down Excel vba filter columns with combobox Excel vba what is the excel vba to find a value in a cell and return the row and column of that cell? Formula for sorting numbers in excel How to put patients number 1 to 100 in columns in excel sheet Sort data by cell color in excel 2003