Merge rows of similar data [Solved/Closed]

Question

Merge rows of similar data [Solved/Closed]

Report

Jay - Mar 30, 2010 at 10:21 AM
rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

- Mar 30, 2010 at 11:51 AM

Hi,

I am trying to merge various rows of data with a common headin 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 dont 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,

Thanks!

Merge rows of similar data
Excel - How to merge rows of similar data? - How-To - Excel
Merge adjacent rows with same data in excel - Forum - Excel
Merge rows in excel based on criteria ✓ - Forum - Excel
Excel Macro to insert row based on data ✓ - Forum - Excel
Split data into several rows of same data ✓ - Forum - Excel

1 reply

Ask a question

rizvisa1 · Answer 1 · 2010-03-30T11:51:02-0400

Answer 1 / 1

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

765
Mar 30, 2010 at 11:51 AM

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)))

Merge rows of similar data [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!