| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting a number of rows into a single column
Hi there everyone
I have a table of data 10 rows and 10 columns wide with some blanks in between. Is there a way to format it to a single column of data (order doesn't matter). The output essentially just needs to be one column of data, 1 cell wide. If the blanks can be eliminated, nothing like it... if not, even then I can live with that!! Thanks guys, Appreciate. Raj. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting a number of rows into a single column
Have a look at the code found at this google search thread.
http://snipurl.com/uxol Gord Dibben MS Excel MVP On Mon, 14 Aug 2006 13:09:02 -0700, Raj wrote: Hi there everyone I have a table of data 10 rows and 10 columns wide with some blanks in between. Is there a way to format it to a single column of data (order doesn't matter). The output essentially just needs to be one column of data, 1 cell wide. If the blanks can be eliminated, nothing like it... if not, even then I can live with that!! Thanks guys, Appreciate. Raj. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting a number of rows into a single column
Thanks Gord... will try it out tonight and will let you know the outcome...
thanks again Raj "Raj" wrote: Hi there everyone I have a table of data 10 rows and 10 columns wide with some blanks in between. Is there a way to format it to a single column of data (order doesn't matter). The output essentially just needs to be one column of data, 1 cell wide. If the blanks can be eliminated, nothing like it... if not, even then I can live with that!! Thanks guys, Appreciate. Raj. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting a number of rows into a single column
Hi again Gord
I tried copy pasting the macro to the ToolsMacroVB editorSheet1InsertModule. Am I doing anything wrong? My skills are quite basic with this? Would appreciate if you could explain a little more. Thanks Raj "Raj" wrote: Thanks Gord... will try it out tonight and will let you know the outcome... thanks again Raj "Raj" wrote: Hi there everyone I have a table of data 10 rows and 10 columns wide with some blanks in between. Is there a way to format it to a single column of data (order doesn't matter). The output essentially just needs to be one column of data, 1 cell wide. If the blanks can be eliminated, nothing like it... if not, even then I can live with that!! Thanks guys, Appreciate. Raj. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting a number of rows into a single column
Raj
Note that thewre are two versions of the macro at that google post. Copy the second version which Bernie modified then......... First...create a backup copy of your original workbook. To create a General Module, hit ALT + F11 to open the Visual Basic Editor. Hit CRTL + R to open Project Explorer. Find your workbook/project and select it. Right-click and InsertModule. Paste the code in there. Save the workbook and hit ALT + Q to return to your workbook. Run the macro by going to ToolMacroMacros. You can also assign this macro to a button or a shortcut key combo. Gord On Tue, 15 Aug 2006 12:26:02 -0700, Raj wrote: Hi again Gord I tried copy pasting the macro to the ToolsMacroVB editorSheet1InsertModule. Am I doing anything wrong? My skills are quite basic with this? Would appreciate if you could explain a little more. Thanks Raj "Raj" wrote: Thanks Gord... will try it out tonight and will let you know the outcome... thanks again Raj "Raj" wrote: Hi there everyone I have a table of data 10 rows and 10 columns wide with some blanks in between. Is there a way to format it to a single column of data (order doesn't matter). The output essentially just needs to be one column of data, 1 cell wide. If the blanks can be eliminated, nothing like it... if not, even then I can live with that!! Thanks guys, Appreciate. Raj. Gord Dibben MS Excel MVP |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting a number of rows into a single column
Oh! Hi Gord... yes it's working to the point that my column has upto 3 rows
minimum. If my column has less than 3 rows, it's not picking up that particular column of data into the new single column. Is there a way to fix the macro? Thanks Raj "Gord Dibben" wrote: Raj Note that thewre are two versions of the macro at that google post. Copy the second version which Bernie modified then......... First...create a backup copy of your original workbook. To create a General Module, hit ALT + F11 to open the Visual Basic Editor. Hit CRTL + R to open Project Explorer. Find your workbook/project and select it. Right-click and InsertModule. Paste the code in there. Save the workbook and hit ALT + Q to return to your workbook. Run the macro by going to ToolMacroMacros. You can also assign this macro to a button or a shortcut key combo. Gord On Tue, 15 Aug 2006 12:26:02 -0700, Raj wrote: Hi again Gord I tried copy pasting the macro to the ToolsMacroVB editorSheet1InsertModule. Am I doing anything wrong? My skills are quite basic with this? Would appreciate if you could explain a little more. Thanks Raj "Raj" wrote: Thanks Gord... will try it out tonight and will let you know the outcome... thanks again Raj "Raj" wrote: Hi there everyone I have a table of data 10 rows and 10 columns wide with some blanks in between. Is there a way to format it to a single column of data (order doesn't matter). The output essentially just needs to be one column of data, 1 cell wide. If the blanks can be eliminated, nothing like it... if not, even then I can live with that!! Thanks guys, Appreciate. Raj. Gord Dibben MS Excel MVP |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting a number of rows into a single column
I cannot replicate your problem even when I have a column with only one entry in
row 1 and nothing else. Answer is: I don't know what to fix Gord On Tue, 15 Aug 2006 14:06:02 -0700, Raj wrote: Oh! Hi Gord... yes it's working to the point that my column has upto 3 rows minimum. If my column has less than 3 rows, it's not picking up that particular column of data into the new single column. Is there a way to fix the macro? Thanks Raj "Gord Dibben" wrote: Raj Note that thewre are two versions of the macro at that google post. Copy the second version which Bernie modified then......... First...create a backup copy of your original workbook. To create a General Module, hit ALT + F11 to open the Visual Basic Editor. Hit CRTL + R to open Project Explorer. Find your workbook/project and select it. Right-click and InsertModule. Paste the code in there. Save the workbook and hit ALT + Q to return to your workbook. Run the macro by going to ToolMacroMacros. You can also assign this macro to a button or a shortcut key combo. Gord On Tue, 15 Aug 2006 12:26:02 -0700, Raj wrote: Hi again Gord I tried copy pasting the macro to the ToolsMacroVB editorSheet1InsertModule. Am I doing anything wrong? My skills are quite basic with this? Would appreciate if you could explain a little more. Thanks Raj "Raj" wrote: Thanks Gord... will try it out tonight and will let you know the outcome... thanks again Raj "Raj" wrote: Hi there everyone I have a table of data 10 rows and 10 columns wide with some blanks in between. Is there a way to format it to a single column of data (order doesn't matter). The output essentially just needs to be one column of data, 1 cell wide. If the blanks can be eliminated, nothing like it... if not, even then I can live with that!! Thanks guys, Appreciate. Raj. Gord Dibben MS Excel MVP Gord Dibben MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
| Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
| HOW DO I RE-NUMBERED MY NUMBER COLUMN AFTER I ADDED ROWS? | Excel Discussion (Misc queries) | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
Hybrid Mode
