how do I transpose a column of 80 numbers into...

  • Thread starter Thread starter beatrice25
  • Start date Start date
One option is create a first row of formulas with =A1, =A11, =A21, ..., =A71,
and copy/paste on the 10 rows.

Hope this helps,
Miguel.
 
enter "a1" in B1;
enter "a9" in C1;
drag across to create a1 to a73;
drag down to complete a1 to a8, a9 to a16, etc
replace ALL "a" with "=a"
 
You are a star. Was not quite right but gave me the idea. I did not kno
you can replace with = and effectively turn text into a formula.

thank you very much
B:
 
OR ... with your data in A1 to A80,
You could simply enter this formula *anywhere*,
And drag across 8 columns,
And then drag down 10 rows:

=INDEX($A$1:$A$80,8*ROWS($1:1)-7+COLUMNS($A:A)-1)

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

in message
You are a star. Was not quite right but gave me the idea. I did not know
you can replace with = and effectively turn text into a formula.

thank you very much
B:)
 
Back
Top