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