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 Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Related

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

0 Comments