MS Excel - Row Data to Columns

[EricAHill]

I have data output where there is an index column and a sample of values for each index. Basically I want to convert:
[tt]
Index | Value
-------------
1 | 2
1 | 5
1 | 3
1 | 1
2 | 1
2 | 1
3 | 5

To a table:

Index 1 | 2 | 3 |
------------------------
2 | 1 | 5 |
5 | 1 | |
3 | | |
1 | | |
[/tt]
Such that I can run some statistics on each index value. Is this possible? I've done it before with VBA, but I was curious if anyone knew any slick alternative.

Thanks,
Eric

 

[chemebabak]

http://files.engineering.com/getfil...8-401b-85ef-2ce3ba79d14e&file=pivot_table.JPG

Create a pivot table

 

[EricAHill]

I'm familiar with PivotTables, but it will not work because I need the actual values split out, not summed (or any of the other pivot functions). I will need to run some more advanced stats on the sampling that requires each sample for each index, and that's where the PivotTable falls a bit short.

Thoughts?