Hello everyone,
I am a long time lurker and excel novice. I have a data set that has multiple entries per date and per group and I would like to combine those entries into a single line. I have given an before and after example below. I am hoping for a VBA solution so that I can save it as a macro but the method to do so escapes me. The actual data set is approximately 250,000 records. I have had mixed success's with various methods and any assistance would be greatly appreciated.
<tbody>
</tbody>
<tbody>
</tbody>
Thank you for your time and have a wonderful day!
I am a long time lurker and excel novice. I have a data set that has multiple entries per date and per group and I would like to combine those entries into a single line. I have given an before and after example below. I am hoping for a VBA solution so that I can save it as a macro but the method to do so escapes me. The actual data set is approximately 250,000 records. I have had mixed success's with various methods and any assistance would be greatly appreciated.
Name | Date | Group | Time |
Jeff | 1/1/19 | G1 | 284 |
Jeff | 1/1/19 | G2 | 767 |
Jeff | 1/1/19 | G3 | 451 |
Jeff | 1/2/19 | G2 | 568 |
Jeff | 1/2/19 | G7 | 489 |
Steve | 1/1/19 | G13 | 654 |
Steve | 1/1/19 | G77 | 789 |
Steve | 1/2/19 | G31 | 413 |
Steve | 1/2/19 | G23 | 877 |
<tbody>
</tbody>
Name | Date | Group | Time |
Jeff | 1/1/19 | G1;G2;G3 | 1502 |
Jeff | 1/2/19 | G2;G7 | 1057 |
Steve | 1/1/19 | G13;G77 | 1443 |
Steve | 1/2/19 | G31;G23 | 1290 |
<tbody>
</tbody>
Thank you for your time and have a wonderful day!