G
Guest
I have some data in a list such as :
01/05/03 Fred
01/05/03 Bert
01/05/03 Bill
08/05/03 Fred
15/05/03 Bert
15/05/03 Bill
I want to represent the data it in a matrix with the dates in the the first column and the names in the first row with the scores at the cell intersections - a bit like :
Fred Bert Bil
01/05/03 3 4
08/05/03 2 0
15/05/03 0 6
Is it possible in Excel? - Can it also be done in Access if the data is the result of a query? - Thanks
01/05/03 Fred
01/05/03 Bert
01/05/03 Bill
08/05/03 Fred
15/05/03 Bert
15/05/03 Bill
I want to represent the data it in a matrix with the dates in the the first column and the names in the first row with the scores at the cell intersections - a bit like :
Fred Bert Bil
01/05/03 3 4
08/05/03 2 0
15/05/03 0 6
Is it possible in Excel? - Can it also be done in Access if the data is the result of a query? - Thanks