Greetings,
I have 2 spreadsheets that I am working with who's data I am trying to merge so that each person will end up with only one row of data. One spreadsheet has the orientation completion date in it, while the other has the checkin date.
I copied and pasted worksheet 2 into the bottom of worksheet one, then sorted the data alphabetically so that if the person has both an orientation completion and checkin date then the rows will be adjacent to one another and look like below.
I am looking for a solution to get it to look like the table at the bottom. Any help would be much appreciated.
Worksheet 1 is set up like this.
[TABLE="class: grid, width: 600"]
<tbody>[TR]
[TD]LNAME
[/TD]
[TD]FNAME
[/TD]
[TD]THIS COLUMN BLANK
[/TD]
[TD]ORIENTATION COMPLETION DATE
[/TD]
[/TR]
[TR]
[TD]SMITH
[/TD]
[TD]JANE
[/TD]
[TD][/TD]
[TD]08/12/2017
[/TD]
[/TR]
[TR]
[TD]JACK
[/TD]
[TD]JIM
[/TD]
[TD][/TD]
[TD]08/12/2017
[/TD]
[/TR]
[TR]
[TD]BIVENS
[/TD]
[TD]SAM
[/TD]
[TD][/TD]
[TD]09/10/2017
[/TD]
[/TR]
</tbody>[/TABLE]
Worksheet 2 is set up like this
[TABLE="class: grid, width: 600"]
<tbody>[TR]
[TD]LNAME
[/TD]
[TD]FNAME
[/TD]
[TD]CHECKIN DATE
[/TD]
[TD]THIS COLUMN BLANK
[/TD]
[/TR]
[TR]
[TD]BIVENS
[/TD]
[TD]SAM
[/TD]
[TD]08/30/2017
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SMITH
[/TD]
[TD]JANE
[/TD]
[TD]07/22/2017
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
What it looks like after combining
[TABLE="class: grid, width: 600"]
<tbody>[TR]
[TD]LNAME
[/TD]
[TD]FNAME
[/TD]
[TD]CHECKIN DATE
[/TD]
[TD]ORIENTATION DATE
[/TD]
[/TR]
[TR]
[TD]BIVENS
[/TD]
[TD]SAM
[/TD]
[TD]08/30/2017
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BIVENS
[/TD]
[TD]SAM
[/TD]
[TD][/TD]
[TD]09/10/2017
[/TD]
[/TR]
[TR]
[TD]JACK
[/TD]
[TD]JIM
[/TD]
[TD][/TD]
[TD]08/12/2017
[/TD]
[/TR]
[TR]
[TD]SMITH
[/TD]
[TD]JANE
[/TD]
[TD]0722/2017
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SMITH
[/TD]
[TD]JANE
[/TD]
[TD][/TD]
[TD]8/12/2017
[/TD]
[/TR]
</tbody>[/TABLE]
WHAT I WANT IT TO LOOK LIKE
[TABLE="class: grid, width: 600"]
<tbody>[TR]
[TD]LNAME
[/TD]
[TD]FNAME
[/TD]
[TD]CHECKIN DATE
[/TD]
[TD]ORIENTATION DATE
[/TD]
[/TR]
[TR]
[TD]BIVENS
[/TD]
[TD]SAM
[/TD]
[TD]08/30/2017
[/TD]
[TD]09/10/2017
[/TD]
[/TR]
[TR]
[TD]JACK
[/TD]
[TD]JIM
[/TD]
[TD][/TD]
[TD]08/12/2017
[/TD]
[/TR]
[TR]
[TD]SMITH
[/TD]
[TD]JANE
[/TD]
[TD]0722/2017
[/TD]
[TD]08/12/2017
[/TD]
[/TR]
</tbody>[/TABLE]
I have 2 spreadsheets that I am working with who's data I am trying to merge so that each person will end up with only one row of data. One spreadsheet has the orientation completion date in it, while the other has the checkin date.
I copied and pasted worksheet 2 into the bottom of worksheet one, then sorted the data alphabetically so that if the person has both an orientation completion and checkin date then the rows will be adjacent to one another and look like below.
I am looking for a solution to get it to look like the table at the bottom. Any help would be much appreciated.
Worksheet 1 is set up like this.
[TABLE="class: grid, width: 600"]
<tbody>[TR]
[TD]LNAME
[/TD]
[TD]FNAME
[/TD]
[TD]THIS COLUMN BLANK
[/TD]
[TD]ORIENTATION COMPLETION DATE
[/TD]
[/TR]
[TR]
[TD]SMITH
[/TD]
[TD]JANE
[/TD]
[TD][/TD]
[TD]08/12/2017
[/TD]
[/TR]
[TR]
[TD]JACK
[/TD]
[TD]JIM
[/TD]
[TD][/TD]
[TD]08/12/2017
[/TD]
[/TR]
[TR]
[TD]BIVENS
[/TD]
[TD]SAM
[/TD]
[TD][/TD]
[TD]09/10/2017
[/TD]
[/TR]
</tbody>[/TABLE]
Worksheet 2 is set up like this
[TABLE="class: grid, width: 600"]
<tbody>[TR]
[TD]LNAME
[/TD]
[TD]FNAME
[/TD]
[TD]CHECKIN DATE
[/TD]
[TD]THIS COLUMN BLANK
[/TD]
[/TR]
[TR]
[TD]BIVENS
[/TD]
[TD]SAM
[/TD]
[TD]08/30/2017
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SMITH
[/TD]
[TD]JANE
[/TD]
[TD]07/22/2017
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
What it looks like after combining
[TABLE="class: grid, width: 600"]
<tbody>[TR]
[TD]LNAME
[/TD]
[TD]FNAME
[/TD]
[TD]CHECKIN DATE
[/TD]
[TD]ORIENTATION DATE
[/TD]
[/TR]
[TR]
[TD]BIVENS
[/TD]
[TD]SAM
[/TD]
[TD]08/30/2017
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BIVENS
[/TD]
[TD]SAM
[/TD]
[TD][/TD]
[TD]09/10/2017
[/TD]
[/TR]
[TR]
[TD]JACK
[/TD]
[TD]JIM
[/TD]
[TD][/TD]
[TD]08/12/2017
[/TD]
[/TR]
[TR]
[TD]SMITH
[/TD]
[TD]JANE
[/TD]
[TD]0722/2017
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SMITH
[/TD]
[TD]JANE
[/TD]
[TD][/TD]
[TD]8/12/2017
[/TD]
[/TR]
</tbody>[/TABLE]
WHAT I WANT IT TO LOOK LIKE
[TABLE="class: grid, width: 600"]
<tbody>[TR]
[TD]LNAME
[/TD]
[TD]FNAME
[/TD]
[TD]CHECKIN DATE
[/TD]
[TD]ORIENTATION DATE
[/TD]
[/TR]
[TR]
[TD]BIVENS
[/TD]
[TD]SAM
[/TD]
[TD]08/30/2017
[/TD]
[TD]09/10/2017
[/TD]
[/TR]
[TR]
[TD]JACK
[/TD]
[TD]JIM
[/TD]
[TD][/TD]
[TD]08/12/2017
[/TD]
[/TR]
[TR]
[TD]SMITH
[/TD]
[TD]JANE
[/TD]
[TD]0722/2017
[/TD]
[TD]08/12/2017
[/TD]
[/TR]
</tbody>[/TABLE]