| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I transpose a column of 80 numbers into...
...10 rows of 8 cells Any ideas Many thanks Beatrice -- beatrice25 ------------------------------------------------------------------------ beatrice25's Profile: http://www.excelforum.com/member.php...o&userid=34505 View this thread: http://www.excelforum.com/showthread...hreadid=543812 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I transpose a column of 80 numbers into...
Copy the range and Paste Special select the "Transpose" check box
-- Thanks for your help - Joe Mac "beatrice25" wrote: ...10 rows of 8 cells Any ideas Many thanks Beatrice -- beatrice25 ------------------------------------------------------------------------ beatrice25's Profile: http://www.excelforum.com/member.php...o&userid=34505 View this thread: http://www.excelforum.com/showthread...hreadid=543812 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I transpose a column of 80 numbers into...
Thanks but that only gives me one row of 80!!! -- simonsmith ------------------------------------------------------------------------ simonsmith's Profile: http://www.excelforum.com/member.php...o&userid=34235 View this thread: http://www.excelforum.com/showthread...hreadid=543812 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I transpose a column of 80 numbers into...
This gives one row of 80 cells, I want 10 rows of 8 cells -- beatrice25 ------------------------------------------------------------------------ beatrice25's Profile: http://www.excelforum.com/member.php...o&userid=34505 View this thread: http://www.excelforum.com/showthread...hreadid=543812 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I transpose a column of 80 numbers into...
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. "beatrice25" wrote: ...10 rows of 8 cells Any ideas Many thanks Beatrice -- beatrice25 ------------------------------------------------------------------------ beatrice25's Profile: http://www.excelforum.com/member.php...o&userid=34505 View this thread: http://www.excelforum.com/showthread...hreadid=543812 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I transpose a column of 80 numbers into...
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" wrote in message ... ..10 rows of 8 cells Any ideas Many thanks Beatrice -- beatrice25 ------------------------------------------------------------------------ beatrice25's Profile: http://www.excelforum.com/member.php...o&userid=34505 View this thread: http://www.excelforum.com/showthread...hreadid=543812 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I transpose a column of 80 numbers into...
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 ------------------------------------------------------------------------ beatrice25's Profile: http://www.excelforum.com/member.php...o&userid=34505 View this thread: http://www.excelforum.com/showthread...hreadid=543812 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I transpose a column of 80 numbers into...
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! ================================================== === "beatrice25" wrote 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 ------------------------------------------------------------------------ beatrice25's Profile: http://www.excelforum.com/member.php...o&userid=34505 View this thread: http://www.excelforum.com/showthread...hreadid=543812 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I transpose a column of 80 numbers into...
Hi RD, Thanks this looks like a good formula and an even better way to go b -- beatrice25 ------------------------------------------------------------------------ beatrice25's Profile: http://www.excelforum.com/member.php...o&userid=34505 View this thread: http://www.excelforum.com/showthread...hreadid=543812 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I transpose a column of 80 numbers into...
Appreciate the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "beatrice25" wrote in message ... Hi RD, Thanks this looks like a good formula and an even better way to go b -- beatrice25 ------------------------------------------------------------------------ beatrice25's Profile: http://www.excelforum.com/member.php...o&userid=34505 View this thread: http://www.excelforum.com/showthread...hreadid=543812 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
| Adding a column of numbers, with a condition | New Users to Excel | |||
| Excel ? Do Not Call Table | Excel Worksheet Functions | |||
| match and count words | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Linear Mode
