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.
Related
- 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).
Subscribe To Our Newsletter!
