Is there a way to select every other row?

[jkap123]

In the end, what i want to be able to do is this:

change

1
2
3
4
5
6

to

1 2
3 4
5 6

 

[Carl Witthoft]

In the end, what i want to be able to do is this:

change

1
2
3
4
5
6

to

1 2
3 4
5 6

Do you want to change an array permanently, or do you want to map it to
another region or sheet in the new layout?

If the latter, there are a variety of ways to pick the desired rows,
along the lines of =indirect(concatenate("A",row()*2) {for getting
cells from column A}

If the former, I have to admit I often dump the data into a text
document and use the excellent regexp-like editing tools in TextWrangler
(or even Word) to turn tabs or commas into paragraph marks as desired,
then dump back into Excel.

 

[jkap123]

thanks. that's helpful.

think i'll try using textwrangler or word.

 

[JE McGimpsey]

In the end, what i want to be able to do is this:

change

1
2
3
4
5
6

to

1 2
3 4
5 6

One way:

In adjacent columns (say, B & C)

B1: =INDEX(A:A,ROW()*2-1)
C1: =INDEX(A:A,ROW()*2)

Select B1:C1 and copy down as far as necessary.

Select columns B:C. Copy. Choose Edit/Paste Special, selecting the
Values radio button.

Delete column A.

 

[Phillip Jones]

One way:

In adjacent columns (say, B & C)

B1: =INDEX(A:A,ROW()*2-1)
C1: =INDEX(A:A,ROW()*2)

Select B1:C1 and copy down as far as necessary.

Select columns B:C. Copy. Choose Edit/Paste Special, selecting the
Values radio button.

Delete column A.

On a Mac some times holding down Shift key while clicking on non
contingent rows. (could be every other row , ever second row every 5th row).

This may or may not work in Excel though in most applications you can
click on rows of items not directly together by this method. It does
work in word.
--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>

 

[Harvey Waxman]

On a Mac some times holding down Shift key while clicking on non
contingent rows. (could be every other row , ever second row every 5th row).

I think it's the cmd key that does this.

 

[Phillip Jones]

I think it's the cmd key that does this.

My bad! Your right its the Cmd (command [open apple or Cloverleaf])
key. shift allow you to click on each row or scroll down and highlight
a group.
--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>

 

[jkap123]

thanks to everyone for the input