Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Dear Sir
Lets consider the following worksheet: A B C D 1 12 26 78 88 2 21 14 65 52 3 32 61 42 31 7 12 8 21 9 32 10 26 11 14 12 61 13 78 14 65 15 42 16 88 17 52 18 31 May I know if you have a formula to tranpose content in cell A1: D3 to a single Column A ( A7: A18) as ilustrated above ? Any formula to input at cell A7 and copy down to get the straight answer ? Thanks Low -- A36B58K641 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2002 - link columns across workgroups | Excel Discussion (Misc queries) | |||
Can I hide rows in Excel 2002 using a formula in a cell? | Excel Discussion (Misc queries) | |||
Excel 2002 Unhide Columns Shortcut?? | Excel Discussion (Misc queries) | |||
I cannot delete rows or columns in Excel 2002. How do I fix this? | Setting up and Configuration of Excel | |||
Open txt file with more than 256 columns (how to tranpose in rows)? | Excel Discussion (Misc queries) |