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

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,185
Messages
5,857,833
Members
431,900
Latest member
Paradime0346

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