how to join a pivot table functionality into an existing table

hello

I have one table with 14 rows (employee information including an employee nr)
in a second large table I have raw data containing

example view (this table have 600 rows)

A is employee nr B is order nr C is time used

....A.................B................C....................D...........E...........................F.............G
13993.........156 019......2,43...........TIMER.........0..................Z569KAA..Planlagt
12651.........395 122......1,2..............TIMER........0..................Z569PON..Startet
12661.........395 122.....1,08............TIMER.........0..................Z569PON..Startet
13547.........395 122.....0,57............TIMER.........0..................Z569PON..Startet
12657.........416 091.....-2,8..............QTY............2,8..............Z569HH......Avrapportert
12657.........416 091.....-0,9..............QTY............0,9..............Z569HH......Avrapportert
12651.........438 554......0,8..............TIMER........0.................Z569PON....Avrapportert
12651.........438 554......0,6..............TIMER........0..................Z569PON...Avrapportert
12651.........438 554.....0,45............TIMER.........0.................Z569PON....Avrapportert
12649.........456 267.....2,34............TIMER.........0.................Z569ARJ.....Avrapportert
12649.........456 267......0,93...........TIMER.........0.................Z569ARJ.....Avrapportert
12649.........462 211......3,85...........TIMER.........0.................Z569TNA......Avrapportert

I want to be able to find all the orders connected with each of the employees and for each ordernumber I want to sum the hours spent on them. I would like this to be returned as a row underneath each employee.

If the data is sorted by order as implied - use the SUBTOTAL feature (add a header row first) - this can be found in the DATA tab on the Ribbon.

if needed sort the table by employee and then by order prior to inserting the SUBTOTAL

I would suggest to avoid any further confusion you post a sample workbook with both "before" and "after" sheets so people can better assist.

If the existing data set resides in a Data Table (I presumed not given lack of headers) then you can not use the Subtotal functionality.
If the data exists in a standard range then Subtotal does what you requested (once header row added), or at least that is my belief based on the information provided thus far.

Not to sound like a "broken record"...

Originally Posted by DonkeyOte

post a sample workbook with both "before" and "after" sheets so people can better assist.

As it stands there is little to work with given your "original" table does not show the source transactions

Note: the SUBTOTAL function can display the subtotals either above or below the transactional info of any given group - this is an option when it is configured - it defaults to below whereas you appear to want above.

Hello

This is beginning to become difficult. If you want me to, I can mail you the whole workbook

Please send a mail to and I will send you the workbook.

Originally Posted by KORT

This is beginning to become difficult.

Not really.

When you reply click the paperclip icon (if you can not see it first click GoAdvanced) - and attach your file.

Also, unless it is your intention to be spammed to oblivion I would strongly advise you remove your email address from your prior post.