So I am trying to create a Casino log to track my trips in Excel. My data is entered so that the Column headings go along the first column and the Trip Dates go along the top row.
The problem I'm having is how do I perform a pivot table on this data in this format so that I can generate useful information like total win/loss to Date or amount of food Comped?
Does the Data have to be rearranged or can it be used in it's current format?
Thank You!
The problem I'm having is how do I perform a pivot table on this data in this format so that I can generate useful information like total win/loss to Date or amount of food Comped?
Does the Data have to be rearranged or can it be used in it's current format?
Sample Casino Diary.xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | |||
2 | Date | 1/1/2021 | 1/15/2021 | 1/20/2021 | 2/1/2021 | 3/1/2021 | ||
3 | Casino | Harrrahs | Ballys | Borgata | Harrahs | Tropicana | ||
4 | Win Loss | -100 | 300 | 250 | -50 | 0 | ||
5 | Food | 10 | 20 | 50 | 100 | 25 | ||
Sheet1 |
Thank You!