transpose links from a column to a row

G

Guest

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
 
A

Ardus Petus

You must validate your TRANSPOSE formula with Ctrl-Shift-Enter since it's an
array formula

HTH
 
G

Guest

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.
 
G

Gary

This works Tim....I tried it.

Miguel Zapico said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

LINEST multiple known_x's separated arrays 5
Copying formulas in Columns and transpose to rows? 5
Reverse Transpose? 4
Copy Transpose and Link Data 1
Transpose 2
transpose array of non-adjacent cells 3
Transpose data and retain links to original data 2
Transpose and Paste Link 2

Top