tags:

views:

50

answers:

1
Q: 

Excel Concatenate Rows

Hi, I have this excel worksheet

A          B          c   
foo1       joo1       loo1
foo1       joo2       loo2
foo2       joo3       loo3
foo2       joo4       loo4
foo2       joo5       loo5

Now I want this

A          B                  c   
foo1       joo1, joo2         loo1, loo2
foo2       joo3, joo4, joo5   loo3, loo4, loo5

How do I do this, preferably with GUI?

+1  A: 
Pete  2010-10-18 22:19:37
Hi Pete, Never written a macro prior. However from the looks of the code did something similar- Basically I applied a unique filter to the first column, copied the second column, deleted the copied cells, removed the filter, resorted the second column, reapplied the filter and so on --> until I had no more filled cells in second column. At the end of it, I had 5 columns sitting sideby side - then concatenated them. Came out perfectly -- it wasn't "programming" though! Thanks for your help.
RisingSun  2010-10-18 23:45:20
I'm glad it worked out and you could use my answer at least as a model.
Pete  2010-10-19 13:07:09

related questions

Top ten ordering in Excel based on complex team rules
Exposing .net methods as Excel functions?
Hiding data points in Excel line charts
Options for PivotTables in Excel
How do I create a status dialog box in Excel
Killing Excel.EXE on server
Modifying a spreadsheet using a VB macro
Count a list of cells with the same background color
Is there anything wrong with this query?
Excel VBA: Alternative IDE
Insert current date in Excel template at creation
Excel: list ranges targeted by INDIRECT formulas
What is the best way to package and distribute an Excel application.
Using Interop with C#, Excel Save changing original. How to negate this?
Using VLOOKUP in an array formula on Google Spreadsheets
How do I save a datagrid to excel in vb.net?
Alternating coloring groups of rows in Excel
How do you prevent leading zeros from being stripped when importing an excel doc using c#
How do I find the Excel column name that corresponds to a given integer?
Accessing Excel data source running SSIS package on 64 bit server
.NET - Excel ListObject autosizing on databind
Reading Excel files from C#
Does anyone have .Net Excel IO component benchmarks?
Refresh Excel VBA Function Results
What is a good web-based Grid that accepts Excel clipboard data?