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

[beatrice25]

...10 rows of 8 cells

Any ideas

Many thanks

Beatric

 

[Guest]

Copy the range and Paste Special select the "Transpose" check box

 

[simonsmith]

Thanks but that only gives me one row of 80!!!

 

[beatrice25]

This gives one row of 80 cells, I want 10 rows of 8 cells

 

[Guest]

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.

 

[PY & Associates]

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"

 

[beatrice25]

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:

 

[RagDyeR]

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

 

[beatrice25]

Hi RD,

Thanks this looks like a good formula and an even better way to go

b

 

[Ragdyer]

Appreciate the feed-back.