Hi, I have data that looks like this starting at A1 - A5 & A1 - E1:
Ben Dan Ike Tim Jon
Dan
Ike
Tim
Jon


I need it to look like this:
Ben Dan Ike Tim Jon
Dan Dan Ike Tim Jon
Ike Ike Ike Tim Jon
Tim Tim Tim Tim Jon
Jon Jon Jon Jon Jon

Any Suggestions?