Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to read online the best way to create a straight table and the differences between that and a pivot table. Does anyone know a good place to read the differences? I am also trying to create a table and I'd like to create a mini table to show the growth from month to month. Right now my striaght table looks like this:
Month | Sandwhich | Order |
July | Grilled Cheese | 15 |
Aug | Grilled Cheese | 30 |
Sept | Grilled Cheese | 25 |
July | Peanut Butter and Jelly | 30 |
Aug | Peanut Butter and Jelly | 50 |
Sept | Peanut Butter and Jelly | 60 |
July | Ham and Cheese | 45 |
Aug | Ham and Cheese | 42 |
Sept | Ham and Cheese | 17 |
Is there anyway to show each sandwich only once sandwhich then show the mini table the change in order numbers from month to month?
Here is a pretty basic example, but it might get you started.
Thanks for the reply, sorry to be a pain, but I have the personal version and I cannot open this file, would you be able to paste the code for it, or would I not be able to read it just by code?