Hoping someone can help with this. I do scheduling. I download a report into Excel that has multiple rows per employee. The number of rows per employee may vary for each download (usually not over 200 lines per report). I'm looking for a way to combine the information from each employee row into a single row. I'm pretty comfortable with Excel am not afraid of macros although I'm a novice in creating them.
Current Format
[TABLE="width: 1127"]
<tbody>[TR]
[TD]Tech Team[/TD]
[TD]Branch[/TD]
[TD]Employee[/TD]
[TD]Fri
3/22/2019[/TD]
[TD]Sat
3/23/2019[/TD]
[TD]Sun
3/24/2019[/TD]
[TD]Mon
3/25/2019[/TD]
[TD]Tue
3/26/2019[/TD]
[TD]Wed
3/27/2019[/TD]
[TD]Thu
3/28/2019[/TD]
[TD]Fri
3/29/2019[/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD="align: right"]33[/TD]
[TD]Smith, Jim[/TD]
[TD]9:00A-5:30P[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD]9:00A-5:30P[/TD]
[TD]9:00A-5:30P[/TD]
[TD]9:00A-5:30P[/TD]
[TD]9:00A-5:30P[/TD]
[TD]9:00A-5:30P[/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD="align: right"]33[/TD]
[TD]Smith, Jim[/TD]
[TD] Standby TR 1:00[/TD]
[TD][/TD]
[TD][/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD="align: right"]33[/TD]
[TD]Jones, Bob[/TD]
[TD]8:00A-5:00P[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Vacation 8:00[/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD="align: right"]33[/TD]
[TD]Jones, Bob[/TD]
[TD] Standby TR 1:00[/TD]
[TD]8:00A-11:00P x
//////Standby TR[/TD]
[TD]8:00A-11:00P x
//////Standby TR[/TD]
[TD]2:00P-11:00P[/TD]
[TD]2:00P-11:00P[/TD]
[TD]2:00P-11:00P[/TD]
[TD]2:00P-11:00P[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Red[/TD]
[TD="align: right"]42[/TD]
[TD]Johnson, Steve[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD]8:00A-4:30P[/TD]
[TD]8:00A-4:30P[/TD]
[TD]8:00A-4:30P[/TD]
[TD]8:00A-4:30P[/TD]
[TD]8:00A-4:30P[/TD]
[/TR]
[TR]
[TD]Red[/TD]
[TD="align: right"]42[/TD]
[TD]Johnson, Steve[/TD]
[TD]2:00P-10:30P[/TD]
[TD][/TD]
[TD][/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[/TR]
[TR]
[TD]Red[/TD]
[TD="align: right"]42[/TD]
[TD]Johnson, Steve[/TD]
[TD]10:30P-11:00P x
//////Standby TR[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]4:30P-11:00P x
//////Standby TR[/TD]
[/TR]
</tbody>[/TABLE]
Desired Result
[TABLE="width: 1127"]
<tbody>[TR]
[TD]Tech Team[/TD]
[TD]Branch[/TD]
[TD]Employee[/TD]
[TD]Fri
3/22/2019[/TD]
[TD]Sat
3/23/2019[/TD]
[TD]Sun
3/24/2019[/TD]
[TD]Mon
3/25/2019[/TD]
[TD]Tue
3/26/2019[/TD]
[TD]Wed
3/27/2019[/TD]
[TD]Thu
3/28/2019[/TD]
[TD]Fri
3/29/2019[/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD="align: right"]33[/TD]
[TD]Smith, Jim[/TD]
[TD]9:00A-5:30P Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD]9:00A-5:30P Standby TR 1:00[/TD]
[TD]9:00A-5:30P Standby TR 1:00[/TD]
[TD]9:00A-5:30P Standby TR 1:00[/TD]
[TD]9:00A-5:30P Standby TR 1:00[/TD]
[TD]9:00A-5:30P Standby TR 1:00[/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD="align: right"]33[/TD]
[TD]Jones, Bob[/TD]
[TD]8:00A-5:00P Standby TR 1:00[/TD]
[TD] Standby TR 1:00//////Standby TR[/TD]
[TD]8:00A-11:00P x
//////Standby TR Standby TR 1:00[/TD]
[TD]2:00P-11:00P Standby TR 1:00[/TD]
[TD]2:00P-11:00P Standby TR 1:00[/TD]
[TD]2:00P-11:00P Standby TR 1:00[/TD]
[TD]2:00P-11:00P Standby TR 1:00[/TD]
[TD] Vacation 8:00[/TD]
[/TR]
[TR]
[TD]Red[/TD]
[TD="align: right"]42[/TD]
[TD]Johnson, Steve[/TD]
[TD]2:00P-10:30P 10:30P-11:00P x
//////Standby TR Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD]8:00A-4:30P Standby TR 1:00[/TD]
[TD]8:00A-4:30P Standby TR 1:00[/TD]
[TD]8:00A-4:30P Standby TR 1:00[/TD]
[TD]8:00A-4:30P Standby TR 1:00[/TD]
[TD]8:00A-4:30P Standby TR 1:00[/TD]
[/TR]
</tbody>[/TABLE]
Any help is greatly appreciated!!
Current Format
[TABLE="width: 1127"]
<tbody>[TR]
[TD]Tech Team[/TD]
[TD]Branch[/TD]
[TD]Employee[/TD]
[TD]Fri
3/22/2019[/TD]
[TD]Sat
3/23/2019[/TD]
[TD]Sun
3/24/2019[/TD]
[TD]Mon
3/25/2019[/TD]
[TD]Tue
3/26/2019[/TD]
[TD]Wed
3/27/2019[/TD]
[TD]Thu
3/28/2019[/TD]
[TD]Fri
3/29/2019[/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD="align: right"]33[/TD]
[TD]Smith, Jim[/TD]
[TD]9:00A-5:30P[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD]9:00A-5:30P[/TD]
[TD]9:00A-5:30P[/TD]
[TD]9:00A-5:30P[/TD]
[TD]9:00A-5:30P[/TD]
[TD]9:00A-5:30P[/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD="align: right"]33[/TD]
[TD]Smith, Jim[/TD]
[TD] Standby TR 1:00[/TD]
[TD][/TD]
[TD][/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD="align: right"]33[/TD]
[TD]Jones, Bob[/TD]
[TD]8:00A-5:00P[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Vacation 8:00[/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD="align: right"]33[/TD]
[TD]Jones, Bob[/TD]
[TD] Standby TR 1:00[/TD]
[TD]8:00A-11:00P x
//////Standby TR[/TD]
[TD]8:00A-11:00P x
//////Standby TR[/TD]
[TD]2:00P-11:00P[/TD]
[TD]2:00P-11:00P[/TD]
[TD]2:00P-11:00P[/TD]
[TD]2:00P-11:00P[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Red[/TD]
[TD="align: right"]42[/TD]
[TD]Johnson, Steve[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD]8:00A-4:30P[/TD]
[TD]8:00A-4:30P[/TD]
[TD]8:00A-4:30P[/TD]
[TD]8:00A-4:30P[/TD]
[TD]8:00A-4:30P[/TD]
[/TR]
[TR]
[TD]Red[/TD]
[TD="align: right"]42[/TD]
[TD]Johnson, Steve[/TD]
[TD]2:00P-10:30P[/TD]
[TD][/TD]
[TD][/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[/TR]
[TR]
[TD]Red[/TD]
[TD="align: right"]42[/TD]
[TD]Johnson, Steve[/TD]
[TD]10:30P-11:00P x
//////Standby TR[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]4:30P-11:00P x
//////Standby TR[/TD]
[/TR]
</tbody>[/TABLE]
Desired Result
[TABLE="width: 1127"]
<tbody>[TR]
[TD]Tech Team[/TD]
[TD]Branch[/TD]
[TD]Employee[/TD]
[TD]Fri
3/22/2019[/TD]
[TD]Sat
3/23/2019[/TD]
[TD]Sun
3/24/2019[/TD]
[TD]Mon
3/25/2019[/TD]
[TD]Tue
3/26/2019[/TD]
[TD]Wed
3/27/2019[/TD]
[TD]Thu
3/28/2019[/TD]
[TD]Fri
3/29/2019[/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD="align: right"]33[/TD]
[TD]Smith, Jim[/TD]
[TD]9:00A-5:30P Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD]9:00A-5:30P Standby TR 1:00[/TD]
[TD]9:00A-5:30P Standby TR 1:00[/TD]
[TD]9:00A-5:30P Standby TR 1:00[/TD]
[TD]9:00A-5:30P Standby TR 1:00[/TD]
[TD]9:00A-5:30P Standby TR 1:00[/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD="align: right"]33[/TD]
[TD]Jones, Bob[/TD]
[TD]8:00A-5:00P Standby TR 1:00[/TD]
[TD] Standby TR 1:00//////Standby TR[/TD]
[TD]8:00A-11:00P x
//////Standby TR Standby TR 1:00[/TD]
[TD]2:00P-11:00P Standby TR 1:00[/TD]
[TD]2:00P-11:00P Standby TR 1:00[/TD]
[TD]2:00P-11:00P Standby TR 1:00[/TD]
[TD]2:00P-11:00P Standby TR 1:00[/TD]
[TD] Vacation 8:00[/TD]
[/TR]
[TR]
[TD]Red[/TD]
[TD="align: right"]42[/TD]
[TD]Johnson, Steve[/TD]
[TD]2:00P-10:30P 10:30P-11:00P x
//////Standby TR Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD] Standby TR 1:00[/TD]
[TD]8:00A-4:30P Standby TR 1:00[/TD]
[TD]8:00A-4:30P Standby TR 1:00[/TD]
[TD]8:00A-4:30P Standby TR 1:00[/TD]
[TD]8:00A-4:30P Standby TR 1:00[/TD]
[TD]8:00A-4:30P Standby TR 1:00[/TD]
[/TR]
</tbody>[/TABLE]
Any help is greatly appreciated!!