Combine several like rows
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. |
Combine several like rows
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. |
All times are GMT +1. The time now is 06:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com