Combining Rows & deleting duplicates based on column values

[Gidget04060]

Good Evening,

I have an excel export containing columns A through R.

What I need is a macro that will run through to last row of data and merge rows based on like values in certain columns.

For example:
If Column A,B,C & F match then merge rows. However, some columns may have information that do not match and would like the values to separated by comma in the merged row.

Starting data:

Actual Start Date	Planned End Date	Stage Status	Stage Actual Start Date	Stage Planned End Date	Stage On Time Status	Assigned To (Role)	Assigned To (Contact)
09/08/2017 08:57	07/11/2017 10:31	Not Started		07/11/2017 10:31	Pending	Project Manager	Email Eaxmple 1
09/08/2017 08:57	07/11/2017 10:31	In Progress	09/08/2017 08:57	07/11/2017 10:31	Late	External Approvers	Email Example 2
09/08/2017 08:57	07/11/2017 10:31	In Progress	09/08/2017 08:57	07/11/2017 10:31	Late	External Approvers	Email Example 3

<colgroup><col span="3"><col><col><col><col><col></colgroup><tbody>
</tbody>

Result:

Actual Start Date	Planned End Date	Stage Status	Stage Actual Start Date	Stage Planned End Date	Stage On Time Status	Assigned To (Role)	Assigned To (Contact)
09/08/2017 08:57	07/11/2017 10:31	Not Started, In Progress	09/08/2017 08:57	07/11/2017 10:31	Pending, Late	Project Manager, External Approvers	Email Eaxmple 1, Email Example 2, Email Example 3

<colgroup><col span="3"><col><col><col><col><col></colgroup><tbody>
</tbody>

Any help would be so appreciated.

Thank you in advance!

 

[Peter_SSs]

Re: Help with Combining Rows & deleting duplicates based on column values

Welcome to the MrExcel board!

It isn't entirely clear to me. You said to merge them if A, B, C and F matched, but then your example merged a row where that was not the case.
So how do we tell which rows to merge and which rows not to merge?

 

[Mike Szczesny]

If I understand this correctly, you want remove identical items (starting date), but also concatenate all items (in one cell) for that one specific item. However, I can provide you only with a non-macro solution.