Need to populate value in different view

[asi234]

I'm using excel 2010.
I would like to change the format from "Room List" to Result. Currently, manually paste the values. I'm looking for a faster solution as i have 100 rooms in my original list.
Below is the example. Please help me.

Room List

Room Name	Month	Accuracy
Room1 <tbody> </tbody>	Jan-13	50
Room1	Apr-13	100
Room1	Jul-13	20
Room1	Oct-13	20
Room2	Jan-13	100
Room2	Apr-13	100
Room2	Jul-13	100
Room2	Feb-13	50
Room3	Oct-13	100

<tbody>
</tbody>

Result:

Room Name	Jan-13	Feb-13	Apr-13	Jul-13	Oct-13
Room1	50	n/a	100	20	20
Room2	100	50	100	100	n/a
Room3	n/a	n/a	n/a	n/a	100

<tbody>
</tbody>

 

[Paella1]

You need a Pivot Table.

Highlight thae Range (including the headers). Select Insert -> Pivot Table -> Pivot Table.

At the dialog box choose New Worksheet.

Then you will get a blank table and on the right will appear your column headings. Drag Room Name to the Column Heading area in the table. Drag Month to the Row Heading Area. Then drag Accuracy to the main section of the table, and make sure it is set to sum (check at the bottom right of the screen).

This will take less than 10 seconds when you get the hang of it.