macro for sorting data from one column to multiple columns

Hi,

I have been trying to figure out how I could sort data so I can have data from one column be sorted and moved over to different columns based off of sample ID. So here is the scenario:

I have three columns that I would like to sort.

Column A contains sample ID
Column B has type of test (3 types of tests total)
Column C has the test results

I would like to see the test results side by side by the type of tests.

So I would need column a with sample ID, a column with results of test A, colulmn with results of test B, and a column with results of test C.

Can anyone help on how i can do this? I have thousands of data to go through and match up, and this is so frustrating =(

Please attach a sample workbook so we can help you better.