extracting values from columns B and C based on column A

[newscientist_au]

Hi
Just wondering if there is an easy way to do the following:
1) I have a list of values in column A, B and C.
2) Can I selectively pull out all values in B and C (into separate columns) that correspond to a particular value in A?


all values in A are integers.


A B C
1 2.5 3.5
1 3.5 4.5
2 3.9 3
2 4.2 3
2 5.6 4.2
3 7.8 5.2
3 8.6 4.2
3 4.2 2.3
4 3.5 8.2
4 6.7 3.0
4 8 2




Desired output:
1B 1C 2B 2C 3B 3C 4B 4C
2.5 3.5 3.9 3 7.8 5.2 3.5 8.2
3.5 4.5 4.2 3 8.6 4.2 6.7 3
5.6 4.2 4.2 2.3 8 2




I want to put all values from B and C in separate columns that have corresponding value of 1. similarly I want to repeat this for all values that correspond to 2 and so on.
even if part of the process could eb automated it would be great- I fear manual copying could be error prone and not feasible for large datasets


Thanks for your help, please let me know if you need more info.