Hi,

Many thanks in advance for looking at my problem.

I have a huge amount of data that has Name, Date and Result (Columns A, B & C - Shown below as Raw Data)

Every week I need to create a table that looks through this data and lists into a table each names results going horizontally in date order (does not need to show the date)(Shown below as Table)

I would then like to have a seperate line chart for each name appear showing their results.

At the moment this can have up to 40+ names and I have to do the table and create each line chart manually.

The names do change week on week and go up and down in number

If there is a very clever thing that can grab the names from the raw data, put them into a table, list their results and then create a line chart for each name I will be so grateful.

The results will never be other that 1 - 4

Any questions, please let me know... and thank you again.

Raw Data
Name Date Result
Name1 02-Sep-11 4
Name2 02-Sep-11 4
Name3 05-Sep-11 1
Name4 05-Sep-11 2
Name5 07-Sep-11 3
Name6 08-Sep-11 3
Name6 08-Sep-11 2
Name4 05-Sep-11 2
Name2 13-Sep-11 3
Name1 13-Sep-11 2
Name1 16-Sep-11 2
Name1 19-Sep-11 2
Name1 19-Sep-11 3
Name4 20-Sep-11 4
Name3 21-Sep-11 3
Name2 15-Sep-11 3
Name3 22-Sep-11 3
Name4 21-Sep-11 2
Name5 21-Sep-11 4
Name6 23-Sep-11 1
Name4 21-Sep-11 2
Name4 21-Sep-11 2
Name5 28-Sep-11 1
Name6 21-Sep-11 1
Name2 27-Sep-11 4
Name6 28-Sep-11 1
Name2 26-Sep-11 4
Name2 20-Sep-11 1
Name2 29-Sep-11 4
Name6 29-Sep-11 4
Name2 28-Sep-11 2
Name4 03-Oct-11 3



Table
Name Result1 Result2 Result3 Result4 Result5 Result6 Result7 Result8 Result9 Result10 Result11
Name 1 4 2 2 3
Name 2 4 3 3 4 4 1 4 2
Name 3 1 3 3
Name 4 2 2 4 2 2 2 3
Name 5 3 4 1
Name 6 3 2 1 1 1 4