I basically want to turn Column B in rows. My SpreadSheet looks like:
Code Value
BB_GOLD_SWAP_1M_BBRG 31MAY4
BB_GOLD_SWAP_1M_BBRG 18AUG4
BB_GOLD_SWAP_1M_BBRG 30AUG4
BB_GOLD_SWAP_1M_BBRG 25DEC3
BB_GOLD_SWAP_1Y_BBRG 26DEC3
BB_GOLD_SWAP_1Y_BBRG 1JAN4
BB_GOLD_SWAP_1Y_BBRG 2APR4
BB_GOLD_SWAP_1Y_BBRG 9APR4
BB_GOLD_SWAP_2M_BBRG 12APR4
BB_GOLD_SWAP_2M_BBRG 3MAY4
BB_GOLD_SWAP_2M_BBRG 31MAY4
BB_GOLD_SWAP_2M_BBRG 18AUG4
BB_GOLD_SWAP_2M_BBRG 30AUG4

I have 65000 rows. I want to Check each row in Column A; if for example
the code in A2 is Equal to the Code in A1 then I want to Copy the Value
in Cell B2 into Cell A3. i.e. the Values Column B must be turned into
Rows. The SpreadSheet will look like:
BB_GOLD_SWAP_1M_BBRG 31MAY4 18AUG4 30AUG4 25DEC3
BB_GOLD_SWAP_1Y_BBRG 26DEC3 1JAN4 2APR4 9APR4
BB_GOLD_SWAP_2M_BBRG 12APR4 3MAY4 31MAY4 18AUG4 30AUG4
In cases where the # values for a particular code exceed 250 then a
second, third (etc) row should be created for the particular code.
PLEASE HELP