A few words of thanks would be greatly appreciated.

Excel - How to merge rows of similar data?

Latest update on March 31, 2010 at 10:09 AM by aakai1056 .

Issue
Solution
Note

Issue

I am trying to merge various rows of data with a common heading in Column A. For example I have the following data:

A 1 0 0 0 1 
B 1 1 0 0 0 
C 1 0 0 0 0 
A 0 1 0 0 0 
B 0 0 1 1 1 
C 0 1 1 1 1

I would like:

A 1 1 0 0 1 
B 1 1 1 1 1 
C 1 1 1 1 1

I don't want to add them together, as they are dates, but i would like to end up with no duplicate rows and all data relevant to the column a heading on the same row,

Solution

You can try this

Copy the unique value to a new sheet( use advance filter)
The you can use this formula

=MAX(SUMPRODUCT((Sheet1!$A$1:$A$6=$A1) * (Sheet1!B$1:B$6)))

Note

Thanks to rizvisa1 for this tip on the forum.

Excel merge rows with same value
Excel merge rows with same id - Best answers
Excel merge rows based on column value - Best answers
Merge rows in excel based on criteria ✓ - Forum - Excel
Excel repeat rows a specified number of times vba ✓ - Forum - Excel
Excel duplicate row multiple times ✓ - Forum - Office Software
Excel copy row to another sheet based on cell value ✓ - Forum - Excel
Copy and insert rows and number of times ✓ - Forum - Excel

This document, titled « Excel - How to merge rows of similar data? », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).

Excel - Compare column A & B give results in column C

Excel - Copy rows from sheet 1 to sheet 2

Issue

Solution

Note

Subscribe To Our Newsletter!