Merging multiple lines into 1 based on common cell info (Name) on each line

[ScottH00]

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

Tech Team	Branch	Employee	Fri 3/22/2019	Sat 3/23/2019	Sun 3/24/2019	Mon 3/25/2019	Tue 3/26/2019	Wed 3/27/2019	Thu 3/28/2019	Fri 3/29/2019
Blue	33	Smith, Jim	9:00A-5:30P	Standby TR 1:00	Standby TR 1:00	9:00A-5:30P	9:00A-5:30P	9:00A-5:30P	9:00A-5:30P	9:00A-5:30P
Blue	33	Smith, Jim	Standby TR 1:00			Standby TR 1:00	Standby TR 1:00	Standby TR 1:00	Standby TR 1:00	Standby TR 1:00
Blue	33	Jones, Bob	8:00A-5:00P	Standby TR 1:00	Standby TR 1:00	Standby TR 1:00	Standby TR 1:00	Standby TR 1:00	Standby TR 1:00	Vacation 8:00
Blue	33	Jones, Bob	Standby TR 1:00	8:00A-11:00P x //////Standby TR	8:00A-11:00P x //////Standby TR	2:00P-11:00P	2:00P-11:00P	2:00P-11:00P	2:00P-11:00P
Red	42	Johnson, Steve	Standby TR 1:00	Standby TR 1:00	Standby TR 1:00	8:00A-4:30P	8:00A-4:30P	8:00A-4:30P	8:00A-4:30P	8:00A-4:30P
Red	42	Johnson, Steve	2:00P-10:30P			Standby TR 1:00	Standby TR 1:00	Standby TR 1:00	Standby TR 1:00	Standby TR 1:00
Red	42	Johnson, Steve	10:30P-11:00P x //////Standby TR							4:30P-11:00P x //////Standby TR

<tbody>
</tbody>

Desired Result

Tech Team	Branch	Employee	Fri 3/22/2019	Sat 3/23/2019	Sun 3/24/2019	Mon 3/25/2019	Tue 3/26/2019	Wed 3/27/2019	Thu 3/28/2019	Fri 3/29/2019
Blue	33	Smith, Jim	9:00A-5:30P Standby TR 1:00	Standby TR 1:00	Standby TR 1:00	9:00A-5:30P Standby TR 1:00	9:00A-5:30P Standby TR 1:00	9:00A-5:30P Standby TR 1:00	9:00A-5:30P Standby TR 1:00	9:00A-5:30P Standby TR 1:00
Blue	33	Jones, Bob	8:00A-5:00P Standby TR 1:00	Standby TR 1:00//////Standby TR	8:00A-11:00P x //////Standby TR Standby TR 1:00	2:00P-11:00P Standby TR 1:00	2:00P-11:00P Standby TR 1:00	2:00P-11:00P Standby TR 1:00	2:00P-11:00P Standby TR 1:00	Vacation 8:00
Red	42	Johnson, Steve	2:00P-10:30P 10:30P-11:00P x //////Standby TR Standby TR 1:00	Standby TR 1:00	Standby TR 1:00	8:00A-4:30P Standby TR 1:00	8:00A-4:30P Standby TR 1:00	8:00A-4:30P Standby TR 1:00	8:00A-4:30P Standby TR 1:00	8:00A-4:30P Standby TR 1:00

<tbody>
</tbody>

Any help is greatly appreciated!!