Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transposing cells
Column A contains 'blocks' of either 7 or 8 cells. For example:
0 2003-2004 0CLOTHESTIME STORE INC C/O GENERAL ACCTG 5325 E HUNTER AVE 03/15/2006 ANAHEIM CA 92807 215.99 217.99 0 200301234 2003-2004 004-018 000027991-8 0 2003-2004 0CROCKER, JAMES R & BARBARA J 41398 SHADOW MOUNTAIN WY HEMET CA 92544 03/15/2006 51.45 51.95 0 200301244 2003-2004 006-165 000028278-1 The first cell in each 'block' contains, in the two leftmost positions, a '0' (zero) and a non-space character. For example: The first cell of the first 'block' contains: 0CLOTHESTIME.... The first cell of the second 'block' contains: 0CROCKER.... I need to tranpose the cells of each block. How do I accomodate the varying number of cells in each 'block'? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transposing cells | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |