Display data list in Matrix

[Andy]

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

 

[GJones]

If I understand your question you can go to Data / Text To
Columns in Excel and it will do it for you. It offers you
different choices on which delimeter to use to create
seperate columns.

Thanks,

Greg

-----Original Message-----
I have some data in a list such as :-

01/05/03 Fred 3
01/05/03 Bert 4
01/05/03 Bill 5
08/05/03 Fred 2
15/05/03 Bert 6
15/05/03 Bill 4

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 Bill
01/05/03 3 4 5
08/05/03 2 0 0
15/05/03 0 6 4

Is it possible in Excel? - Can it also be done in Access

if the data is the result of a query? - Thanks.

 

[Anders S]

Andy,

With the data in separate columns, if not already use Data>Text to Columns, try a Pivot table. It will do what you want and more.

HTH
Anders Silvén