Help with pivot excel! Advice

[go0sebumpz]

I need help what the best approach is and maybe it is creating a pivot table.

So I have 4 Columns:
Column 1) USER ID
Column 2) Hours of user ID on application
Column 3) USER ID on different application
Column 4) Hours on different application

I need to consolidate the USER ID's into one sheet since essentially they are the same USER IDS, but different data in terms of Hours they report.

What is the best method to go about? How can I consolidate all USER IDs into one Column and reflect that they match up to the hours in the respective application?


Example:

ID	Hours in App 1	ID	Hours in App 2
John.doe	1	John.doe	2
John.smith	2	John.smith	2
Henry.Ford	3	Samsung.phone	4

<tbody>
</tbody>

Ideally, I would like it to end up consolidating w/ their respective hours to the application

ID	Hours in App 1	Hours in App 2
John.doe	1	2
John.smith	2	2
Henry.Ford	3	4
Samsung.phone	4	1

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>