Can anyone please help with the following:

I have a table as follows:

Col A Col B Col C
Room No. Code Qty
01 Unit 1
01 W/top 2
01 Sundry 3
02 Unit 5
02 W/top 1
02 Sundry 1
03 Unit 7
03 W/top 4
03 Sundry 3

I need to transpose the table so that Codes are in column A, followed by
each room no. as a column header, with qty's against each code, as follows:


Col A Col B Col C Col D
01 02 03 <--- Room No.'s
Unit 1 5 7
W/top 2 1 4
Sundry 3 1 3

I've tried loookup's and index/match functions, but to no avail.

This is very urgent, so if anyone can help, i would be very grateful.

Kind regards

--
jj