Reorganize data

Hello,

Is there any easy method to tranform the table from Tabel 1 to 2?

TABLE 1
Date Name Level
11/6/2009 A 65.12
12/6/2009 A 65.84
13/6/2009 A 24.65
14/6/2009 A 24.95
15/6/2009 A 12.95
16/6/2009 A 74.65
17/6/2009 A 54.32
18/6/2009 A 41.95
19/6/2009 A 65.54
11/6/2009 B 25.13
12/6/2009 B 43.21
13/6/2009 B 65.12
14/6/2009 B 43.12
15/6/2009 B 64.24
16/6/2009 B 65.12
17/6/2009 B 65.84
18/6/2009 B 24.65
19/6/2009 B 24.95
11/6/2009 C 12.95
12/6/2009 C 74.65
13/6/2009 C 54.32
14/6/2009 C 41.95
15/6/2009 C 65.54
16/6/2009 C 25.13
17/6/2009 C 43.21
18/6/2009 C 65.12
19/6/2009 C 43.12

TABLE 2
Date A B C
11/6/2009 65.12 25.13 12.95
12/6/2009 65.84 43.21 74.65
13/6/2009 24.65 65.12 54.32
14/6/2009 24.95 43.12 41.95
15/6/2009 12.95 64.24 65.54
16/6/2009 74.65 65.12 25.13
17/6/2009 54.32 65.84 43.21
18/6/2009 41.95 24.65 65.12
19/6/2009 65.54 24.95 43.12

See attached file hope it will work for you ......

You can check this thread as well ....

http://www.excelforum.com/excel-gene...33-sum-if.html

A macro version to do the same thing. Remove the last line of code if you do not want the original table removed:

Please Login or Register  to view this content.

You can do it without using VBA .......

http://www.excelforum.com/excel-gene...33-sum-if.html

Each time you run this, do you need the reports to ADD to the tables already created, or does it create a new table each time similar to how my first macro created a unique table based on the data?

Use this one, it will create a chart with any number of dates and any number of names each time you run it.

Please Login or Register  to view this content.

I eliminated the loop so every line isn't individually evaluated.

Thx JB,
I have some problems with it.
The values are zero after the table transformation The Name and Date are all correct.


Attached test and result.

Yeah, my bad. I used the wrong "end row" for the sumproduct() formula being used. Here you go...apologies.

Please Login or Register  to view this content.