merge rows based on the value of field

[Anonymous]

Hello,

I'm looking for a better way to merge rows with the same SerialNumber based on the value of "Status".

For example, this is the original table:

SerialNumber	Date	Status
1	01/23/2015	Inventory
2	07/08/2015	Inventory
1	01/19/2015	Ship Out
3	06/15/2015	Inventory
4	06/15/2015	Inventory
5	06/21/2015	Inventory
3	06/18/2015	Ship Out
6	06/21/2015	Inventory
7	06/21/2015	Inventory
2	08/15/2015	Ship Out
4	06/19/2015	Ship Out
5	08/25/2015	Ship Out

And, I would like to make a table like this:

SerialNumber	Inventory Date	Ship Out Date
1	01/23/2015	01/19/2015
2	07/08/2015	08/15/2015
3	06/15/2015	06/18/2015
4	06/15/2015	06/19/2015
5	06/21/2015	08/25/2015
6	06/21/2015
7	06/21/2015

Thank in advance.

Best,

Josh

[Anonymous]

It doesn't help by removing CreateDate.

[Anonymous]

Turn out I found that the issue of no data after left join is caused by the incorrect filter setting.

Thanks for both advice. They both work but left join is easier.

thanks,

Josh