Rows to Column based on unique identifier and time stamp

[peterhydebank]

Hi All,

Please help me urgently to solve the issue I am facing. I have attached a sample data below. I want to have all values of Product 1, Product 2 and Product 3 in column deleting rows or may be in another sheet. The "Employee Number" are unque number in this case. Another condition is sales employees are entering the data multiple times, I need most recent uploaded sales number only for each Product. The "Date Time" column come as text.



[TABLE="width: 582"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Employee Number[/TD]
[TD]Product Category[/TD]
[TD]Currency[/TD]
[TD]Sales Number[/TD]
[TD]Date Time[/TD]
[/TR]
[TR]
[TD]Peter[/TD]
[TD="align: center"]56457[/TD]
[TD]Product 1[/TD]
[TD]USD[/TD]
[TD="align: right"]700000[/TD]
[TD="align: right"]1/22/2018 18:13[/TD]
[/TR]
[TR]
[TD]Peter[/TD]
[TD="align: center"]56457[/TD]
[TD]Product 2[/TD]
[TD]USD[/TD]
[TD="align: right"]912500[/TD]
[TD="align: right"]1/22/2018 18:15[/TD]
[/TR]
[TR]
[TD]Peter[/TD]
[TD="align: center"]56457[/TD]
[TD]Product 3[/TD]
[TD]USD[/TD]
[TD="align: right"]325000[/TD]
[TD="align: right"]1/22/2018 18:16[/TD]
[/TR]
[TR]
[TD]Peter[/TD]
[TD="align: center"]56457[/TD]
[TD]Prosuct 2[/TD]
[TD]USD[/TD]
[TD="align: right"]350000[/TD]
[TD="align: right"]1/22/2018 18:18[/TD]
[/TR]
[TR]
[TD]Peter[/TD]
[TD="align: center"]56457[/TD]
[TD]Product 1[/TD]
[TD]USD[/TD]
[TD="align: right"]475000[/TD]
[TD="align: right"]1/22/2018 18:20[/TD]
[/TR]
</tbody>[/TABLE]

Thank you