Rearranging datasets using vlookup

Hi,

I have a problem where I have a live dataset going into a master spreadsheet, and I need this arranged differently in a new worksheet.

Example Dataset:

Data Stream	Ref Code	Stage
First	E29182	1
First	E28812	2
First	E21919	3
Second	E27327	2
Second	E23831	3
Third	E28233	1
Third	E28199	2

I need this in a new worksheet/table sorted by stages as columns and data stream as rows, and to return the ref code as the value within the tab

Example of what it should look like:

	Stage 1	Stage 2	Stage 3
First	E29182	E28812	E21919
Second		E27327	E23831
Third	E28233	E28199

Been playing around with vlookups to return the cell value into the correct new column by stages, since this worksheet should be blank, not sure whether I need to hide a look up cell within the new table (eg. ref code) in order to return the value into the correct column so vlook up has a single cell to reference, rather than whole dataset.

=IF(ISNA(VLOOKUP(VLOOKUP(ref code cell, dataset table, 1, false), dataset table="stage 1",1,FALSE)), "" , FALSE)

Realise this formula is incorrect, but if anyone could help me out would be greatly appreciated.

Cheers

Perhaps this pivot table proposal will be helpful.
A helper column (Ref#) is added to the master and populated using: =VALUE(RIGHT(B5,LEN(B5)-1))
In the pivot table Data Stream is in the Row field, Stage is in the Column field and Ref# is in the Value field.
Note that the number formatting for Ref# in the pivot table is "E"0
Let us know if you have any questions.