ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Turn Rows into Columns (https://www.excelbanter.com/excel-programming/322265-turn-rows-into-columns.html)

Marianna[_3_]

Turn Rows into Columns
 
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



All times are GMT +1. The time now is 12:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com