Need Help Creating a Table List

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

Originally Posted by Azam Ali

see attatchment

Hi, Not sure what happened but it is all showing as #NAME?

Originally Posted by Marcol

What version of Excel are you using? Your profile says 2007, but if you open the file with 2003 IFERROR() will return #NAME?, because it doesn't support this function. Just a thought.

Hi,

Yeah, I thought I have 2007 but just checked and it is 2003. Is there anyway to get it to work for this???

Here is Azam Ali's file with Solution 1 adapted for 2003.

Solution 2 (Automatic) can't be converted in the same way because it exceeds the nesting limits of 2003.

Sorry, I don't have time just now to find a workaround for the rest of the workbook.

It is very important that you clearly state the version you need to use the workbook with as this example demonstrates.

I suggest you change your profile to match your version of Excel.