Help with pivot excel! Advice

go0sebumpz

New Member
Joined
Sep 3, 2014
Messages
1
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:


IDHours in App 1IDHours in App 2
John.doe1John.doe2
John.smith2John.smith2
Henry.Ford3Samsung.phone4

<tbody>
</tbody>


Ideally, I would like it to end up consolidating w/ their respective hours to the application
IDHours in App 1Hours in App 2
John.doe12
John.smith22
Henry.Ford34
Samsung.phone41

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

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Watch MrExcel Video

Forum statistics

Threads
1,129,685
Messages
5,637,809
Members
416,983
Latest member
LessThanAverageUser

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top