Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Column A has cells containing:
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 2001-2002 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 A cell starting with a zero, four spaces and a range of years (i.e, 2003-2004 or 2001-2003) is the first cell in a 'block'. For example: This first cell of the first 'block' contains: 0 2003-2004 The first cell of the second 'block' contains: 0 2001-2002 Each 'block' contains either 7 or 8 cells. I need to transpose each 'block'. But how do I handle the varying number of cells in each 'block'? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Transposing cells | Excel Discussion (Misc queries) | |||
Transposing cells | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |