Gidget04060
New Member
- Joined
- Oct 1, 2017
- Messages
- 1
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:
<colgroup><col span="3"><col><col><col><col><col></colgroup><tbody>
</tbody>
Result:
<colgroup><col span="3"><col><col><col><col><col></colgroup><tbody>
</tbody>
Any help would be so appreciated.
Thank you in advance!
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!