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

That is a real beast to do. Have you considered a pivot table instead. Here
is generally how I would go about it. I assume you have a heading row in Row
1. Click anywhere within the data. Choose Data - Pivot Table The wizard will
come up but just choose finish.

Drag the code to the left hand column. Drag the date to the left Column.
Drag the date middle.

This might work...

If not you may need to

"Marianna" wrote:

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