Hi can anyone help?
I am trying to create a table with lots of differing data and the easiest way seems to be to use pivot tables. However I do not want to count or sum or use any other formula with the results, I just want it to display the data. eg If I was tracking the change of car wheels and wanted to display that on a certain date car 1 had its front left tyre changed on another its rear right, and so on and so forth for numerous days and tyres and cars, but wanted to amalgamate this into a large table showing date down the left, car number at the top and the tyre changed against the date and car, how would I go about this without manually inputiing?
Bookmarks