0
Thanks

A few words of thanks would be greatly appreciated.

Excel - How to merge rows of similar data?




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.
0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Published by . Latest update on by aakai1056.

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 (https://ccm.net/).

0 Comments