formula for non-sequential columns

  • Thread starter Thread starter akonealive
  • Start date Start date
A

akonealive

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.
 
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
 
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.
 
Ok, enter these formulae in the cells shown (I think you have a typo):

S1 =G1
S2 =J1

Hope this helps.

Pete
 
Back
Top