# formula for non-sequential columns

1. ## formula for non-sequential columns

I've got data in columns separated by two other columns. I wish to
create a formula in another column that will include the data from
these two non-sequential columns. How do I do this?

Ex: data are found in columns G(rows 1) and J(rows1) and would like to
create formula which lists such data in column S in the following
order: info from column G, row 1 then info from column J, row 1.

Thank you for any assistance. I've pulled out most of what hair I've
got left over this.

2. in column "S"

=G1 & J1

3. ## Re: formula for non-sequential columns

I think this is what you want - enter this formula in S1:

=G1&", "&J1

This will put a comma and a space between the two items.

Hope this helps.

Pete

4. ## Re: formula for non-sequential columns

i apologize for the error. i meant to indicate that I wish the info
from the two columns to be included in column S accordingly:

info from column G, row 1 to be inserted in column S, row 1; and info
from column G, row 1 to be inserted in column S, row 2.

thanks again.

akonealive@gmail.com wrote:
> I've got data in columns separated by two other columns. I wish to
> create a formula in another column that will include the data from
> these two non-sequential columns. How do I do this?
>
> Ex: data are found in columns G(rows 1) and J(rows1) and would like to
> create formula which lists such data in column S in the following
> order: info from column G, row 1 then info from column J, row 1.
>
> Thank you for any assistance. I've pulled out most of what hair I've
> got left over this.

5. ## Re: formula for non-sequential columns

Ok, enter these formulae in the cells shown (I think you have a typo):

S1 =G1
S2 =J1

Hope this helps.

Pete

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1