I have a spreadsheet formatted like this:
1 High V
1 High T
1 High C
1 Low T
1 Low C
2 High V
2 High C
and I would like to format it like this:
1 High V, T, C
1 Low T, C
2 High V, C
In other words, I want to concatenate all of the values in the third column. I know how to do this for a selected number of cells, but I would like to do this for the ENTIRE sheet, and I have over 400 unique values in the first column.
I don't want to use script, I don't know how to use it or what to do with it. I'm using Excel 2007.
Is there any way to do this? How do I do this???
1 High V
1 High T
1 High C
1 Low T
1 Low C
2 High V
2 High C
and I would like to format it like this:
1 High V, T, C
1 Low T, C
2 High V, C
In other words, I want to concatenate all of the values in the third column. I know how to do this for a selected number of cells, but I would like to do this for the ENTIRE sheet, and I have over 400 unique values in the first column.
I don't want to use script, I don't know how to use it or what to do with it. I'm using Excel 2007.
Is there any way to do this? How do I do this???