I use on a regular basis what becomes a very large spreadshhet consisting of
let's just say 26 columns (A thru Z) of data and depending on the job there
could be over 900 rows.

Here is a simplified version of my example:
- Col A: always contains different text
- Col B through Z : each of these columns would have the same values AFTER I
have used the filter to only display like values.
- After filtering I may end up with 40 exactly the same data except for Col A.

Here is what I would like to be able to accomplish:
- 40 rows displayed in one row
- All the text in Col A merged but with CSV.

So in other words - combine several like rows, Comma Seperate the Values in
Col A. Then if required reverse the entire process to 'Split them apart' to
bring them back to the original state.

Take a look at this:
http://www.rondebruin.nl/copy5.htm

I would surmise that one of the examples there will do what you want.

regards,
Ryan---

--
RyGuy


"Dane" wrote:

I use on a regular basis what becomes a very large spreadshhet consisting of
let's just say 26 columns (A thru Z) of data and depending on the job there
could be over 900 rows.

Here is a simplified version of my example:
- Col A: always contains different text
- Col B through Z : each of these columns would have the same values AFTER I
have used the filter to only display like values.
- After filtering I may end up with 40 exactly the same data except for Col A.

Here is what I would like to be able to accomplish:
- 40 rows displayed in one row
- All the text in Col A merged but with CSV.

So in other words - combine several like rows, Comma Seperate the Values in
Col A. Then if required reverse the entire process to 'Split them apart' to
bring them back to the original state.