pivot altervnatives

I am trying to create a pivot table from the following data. into the following format and I am stuck adding the additional row can someone provide assistance please?

I work in a sorting facility and we sort a bunch of fruit and must report on our productivity each week. the numbers represent tons, which some weeks we go through a lot and some we do not. It all depends on how many we receive, and how many people we have working on it. But that aside, I've...

Hello I have a data table (columns A and B) which I could summariseusing a pivot table but don't want to as I want to perform some further work onthe data in the data table itself. I can sum up the values for each person and can do that incolumn C using a simple SUMIF function but as you can...

Hey guys, so I have a pivot that looks something like this: Name | Class | Apples | Oranges | Pears | Cranberries ----|-----|------|-------|-----|----------- Andy | 2015 | 1 | 2 | 3 | 4 Bill | 2015 | 2 | 3 | 2 | 2 Bobby | 2015 | 1 | 3 | 3 | 3 Chester | 2015 | 3 | 1 | 2 | 4 Gerard | 2014 | 2 |...

Hi there, I have a problem that I can demonstrate in simplified way as follows: <tbody> Company Amount A 500 B 200 C 400 A 200 B 400 </tbody> I would like a formula that would first calculate the average over each category (i.e., A = 350, B = 300, and C = 400) and then...