a text array formula

  • Thread starter Thread starter EMCUE
  • Start date Start date
E

EMCUE

Brand new user, appreciate the help!

I have a contact data in a specific vertical index in a single column.

I wanted to set up an array forumla to automatically transpose the data
horizontally. Couldn't do it because obviously the array function can
not use text.

I then tried to set up a simple replacement fuction (=AXX) into each
cell. But that wouldn't work, because as I moved horizontally the
Column would change.

I quit, and then simply did the manual transpose.

Is there an alternative?
 
Hello EMCUE,

Check out the TRANSPOSE function. Ensure the range is of the same size and
confirm with Ctrl + Shift + Enter.

Nb: You cannot change one part of an array if entered like this. An easy
way to select the entire array is to select one cell in the array, press F5
| Specail | Current array.

HTH
 

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

Multiplying Arrays 7
INDEX return multiple columns 1
Help on linking and copying cells 1
transposing an array converts dates into numbers 3
Continuation to equivalent for formula - to Mr. Harlan Grove (and notonly...) 1
Transpose Function 3
Using SUM + INDEX in array formula 5
OLD PROBLEM without SOLUTION , part || 1

Back
Top