I have never built a pivot table. It is my understanding that pivot tables get there data from a spreadsheet that contains the raw data, and then you use the pivot table wizard? This means that my raw data spreadsheet must be built in away that the pivot table wizard can use it. That said could someone look at the beginning of my raw data and tell me if there are going to be problems? I know that I drag column labels into the wizard, but I am using two sets of column headings, I don’t have to use two. This spreadsheet identifies locations of water tanks and there will be at least 60 locations and about 600 water tanks. I would like to put an empty row between every location to make the raw data easier to read but I don’t know if this will screw up the pivot table wizard. After looking at how my data is set up if you have a better way to lay out please feel free to make a suggestion.
I don’t normally do this kind of work but where I am at I am the only one with any kind of experience with excel. My mangers have all this raw data but don’t know how to make the data accessible and useful. I really think that the information would be better as a data base but I have no idea how to do that, or I could just set it up to have all the information so that you could sort the sheet, but this sheet is going to be fairly big and we don’t need all the information most of the time just some of the information so I thought that a pivot table would be the way to go. I have seen how pivot tables work but I have never built a spreadsheet for raw data to use with one. Sorry this was long just trying to give you an idea of what I am trying to do.
Thanks,
Ken
Bookmarks