Hi, I'm trying to separate several datasets from a long table so I can graph the results.
Sample spreadsheet attached
Data is in a table containing a name, date and value
A; B; C;
Cris; 01-Oct-10; 52
Dave; 03-Oct-10; 151
Ella; 03-Oct-10; 65
Fred; 08-Oct-10; 98
Bill; 08-Oct-10; 117
Cris; 08-Oct-10; 62
Cris; 15-Oct-10; 54
Adam; 15-Oct-10; 121
I have used array formulas to separate out the unique dates and names for the axes of
the table that will be used for the graph: eg
.......... Adam; ...Bill; ...Cris; ...Dave; ...Ella; ...Fred
01-Oct-10 .................. 52
03-Oct-10 .............................151 ....65
08-Oct-10 etc etc.... 117 62 98
15-Oct-10 121
The bit I'm struggling with is the array formula to populate the table. It needs to reference the date in the left col and the name above and fill in the corresponding cells.
I expect to use index, match, offset - but I just cant get it to work :-/
Bookmarks