Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
transpose links from a column to a row
I need to transpose a column to a row without using 'Paste Special'. How do i
get the second value when using the formula {=transpose(array)}? tim |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
transpose links from a column to a row
You must validate your TRANSPOSE formula with Ctrl-Shift-Enter since it's an
array formula HTH -- AP "Tim" a écrit dans le message de news: ... I need to transpose a column to a row without using 'Paste Special'. How do i get the second value when using the formula {=transpose(array)}? tim |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
transpose links from a column to a row
In order to show all the array elements, you can select all the cells on the
row that will have elements, and insert the formula in all of them at the same time. For example, if the array have three elements, you can select cells B1, C1 and D1, enter the formula in B1 and click CTRL+SHIFT+ENTER. Hope this helps, Miguel. "Tim" wrote: I need to transpose a column to a row without using 'Paste Special'. How do i get the second value when using the formula {=transpose(array)}? tim |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
transpose links from a column to a row
This works Tim....I tried it.
"Miguel Zapico" wrote in message ... In order to show all the array elements, you can select all the cells on the row that will have elements, and insert the formula in all of them at the same time. For example, if the array have three elements, you can select cells B1, C1 and D1, enter the formula in B1 and click CTRL+SHIFT+ENTER. Hope this helps, Miguel. "Tim" wrote: I need to transpose a column to a row without using 'Paste Special'. How do i get the second value when using the formula {=transpose(array)}? tim |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
transpose links from a column to a row
Thanks guys. that's great
"Gary" wrote: This works Tim....I tried it. "Miguel Zapico" wrote in message ... In order to show all the array elements, you can select all the cells on the row that will have elements, and insert the formula in all of them at the same time. For example, if the array have three elements, you can select cells B1, C1 and D1, enter the formula in B1 and click CTRL+SHIFT+ENTER. Hope this helps, Miguel. "Tim" wrote: I need to transpose a column to a row without using 'Paste Special'. How do i get the second value when using the formula {=transpose(array)}? tim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
how can i multiply two columns | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
transpose a column into many rows | Excel Discussion (Misc queries) |