Hi,
I have a worksheet with two columns of data. Column A contains filenames with dates (i.e. "Activities for 091305"). Column B contains a list of activities (all text). I start by sorting the entire worksheet by Column A so the dates are in ascending order. Then I manually go through and cut and paste all the values from Col B that have common file names. Example:
Col A Col B
Activities for 091305.xls List of activities part 1
Activities for 091305.xls List of activities part 2
The result I'm looking for is:
9/12/2005 List of activities part 1; List of activities part 2
Naturally this is very time consuming and I'm trying to find a better way to accomplish this repetitive task. I had some trouble converting the text date in Col A from ddmmyy to d/m/yyyy format, so I'll settle for being able to combine the cells in Col B and just manually enter the date if necessary.
I have tried the concatenate command using IF statements, but there could be any number of rows that have common filenames so it looks like a loop would be better suited for this task.
Any help is appreciated
I have a worksheet with two columns of data. Column A contains filenames with dates (i.e. "Activities for 091305"). Column B contains a list of activities (all text). I start by sorting the entire worksheet by Column A so the dates are in ascending order. Then I manually go through and cut and paste all the values from Col B that have common file names. Example:
Col A Col B
Activities for 091305.xls List of activities part 1
Activities for 091305.xls List of activities part 2
The result I'm looking for is:
9/12/2005 List of activities part 1; List of activities part 2
Naturally this is very time consuming and I'm trying to find a better way to accomplish this repetitive task. I had some trouble converting the text date in Col A from ddmmyy to d/m/yyyy format, so I'll settle for being able to combine the cells in Col B and just manually enter the date if necessary.
I have tried the concatenate command using IF statements, but there could be any number of rows that have common filenames so it looks like a loop would be better suited for this task.
Any help is appreciated