Hi All,
I basically want to turn Column B in rows. My SpreadSheet lo*oks 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 Cop*y the Value
in Cell B2 into Cell A3. i.e. the Values Column B must be tu*rned 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
Bookmarks