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 - How to merge rows of similar data?
- Merge rows of similar data (Solved) » Forum - Excel
- Excel Macro to insert row based on data (Solved) » Forum - Excel
- Highlighting rows of similar data » Forum - Excel
- How to merge rows in excel » How-To - Excel
- Excel - Add data to new row each time data is entered » How-To - Excel