I have two worksheets w/ data that I want to combine into a single worksheet.
I want to combine rows based upon one column of data that each shares:

worksheet 1:

ID # Name State
1 Bob Ohio
1 Sue Utah
2 Joe Iowa

Worksheet 2:

ID# Location size
1 east 4
2 midwest 6

Combined Worksheet:

ID# Name State Location Size
1 Bob Ohio east 4
1 Sue Utah east 4
2 Joe iowa midwest 6

I am struggling to figure this out.

Any help would be much appreciated. Thanks