I'm seeking suggestions on how to merge to worksheets.

I know how to merge the results using VBA and For loops.

But I figure Excel might have a merge feature I don't know about. And
perhaps you do. And it might be perfectly suited to the task.

Sheet1 looks like

253 A B C D
E F G H
221 Z Y X W
V U T S

253 and 221 are identifiers.


Sheet2 looks like

253 M
N
O
V
221 R
Q
P
Z

And the merged result is


253 A B C D M
E F G H N
O
V
221 Z Y X W R
V U T S Q
P
Z


Thanks.