merging cells from multiple rows into one row

[mooncommand]

Hi there,

After hours spend copy pasting and deleting rows I do hope one of you can help me out.
For my work I need to delete duplicate rows with the same name but keep the information in the (original) cell.

for example I have:
Cells: C D E F
Row 1 Soccer Premier League Holland
Row 2 Soccer Premier League Germany
Row 3 Soccer Premier League Poland Poland

I want to keep row 1 and add the data from row 2 & 3 with the data in the same cells so it will be:
Cells: C D E F
Row 1 Soccer Premier League Holland Germany Poland Poland

As cells D, E, F are empty I would say you can just merge the 3 rows by selecting them and merge. However I have no clue how to do this! if anyone can solve this it would save me hours of work! thank you!

[djfatboyfats]

Cant you just write a formula like

Please Login or Register  to view this content.

or if you wanted to include spaces between the columns then

Please Login or Register  to view this content.

[mooncommand]

Thank you for the reply!

however, this was not what I am looking for, the thing I want to do is selecting 3 rows and move all the data up to the first row.
so the data of C stays in cell c but moves to the top selected row. I see the format of the message got changed I tried to clear things up by making this :
Cells: --------------------------------C-------------- D----------- E----------- F
Row 1 Soccer Premier League Holland
Row 2 Soccer Premier League ---------------Germany
Row 3 Soccer Premier League ----------------------------- Poland -------Poland

I want to keep row 1 and add the data from row 2 & 3 with the data in the same cells so it will be:
Cells: -------------------------------C ------------D----------- E ----------F
Row 1 Soccer-----Premier League----Holland-----Germany ----Poland------ Poland

thx in advance!

[Kaper]

once you attach a sample workbook (see forum rules - how) , it will be easier to understand the real layout

Basically it looks that to do it effectively you need a simple macro similar to this one:

Please Login or Register  to view this content.

could be that you need to check

Please Login or Register  to view this content.

rather than only Column C - but as I said - attachment is best way to show data layout.

The code is pretty simple, so shall be easy to adopt to ones needs.
In real life it is worth considering adding application.screenupdating=false in the code to speed things up.


See in attachment how it works on sample data.