Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi--
I need some help converting data from multiple rows/columns into one column. My data looks like this (numbers starting on row 3): BA BB BC BD BE 2-7-484 2-7-11702 2-7-9690 2-2-9692 2-2-9691 2-2-10289 2-2-8 2-14-4911 2-5-11766 2-5-10638 2-5-11236 and I would like it to look like this in another sheet: 2-7-484 2-7-11702 2-7-9690 2-2-9692 2-2-9691 2-2-10289 2-2-8 2-14-4911 2-5-11766 2-5-10638 2-5-11236 I have a variable number of columns/rows where this data is. But I can have a cell that holds the number of columns and rows. I would like blank cells to be skipped. Any suggestions? Thanks, Jason |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
convert row to columns for multiple rows | Excel Worksheet Functions | |||
Excel Convert Multiple Rows into Multiple Columns | Excel Worksheet Functions | |||
How can I convert a data from multiple rows into 1 column? | Excel Worksheet Functions | |||
Convert multiple columns to rows | Excel Worksheet Functions | |||
how to convert multiple columns of data into one single column? | Excel Worksheet Functions |