combining multiple columns to single column

[Mike]

I teach a high school probability/statistics class. When groups of students
generate experiemental data, the come to the lone computer in the room, and
enter their data in a column with their group name at the the top.

What I'd like to do without tedious copying/pasting is to combine multiple
columns of data, into a single column. Is there some functionality of Excel
which would assist in this task?

Thanks!

 

[JulieD]

Hi Mike

you can use the CONCATENATE() function

=Concatenate(A1, " ", B1, " ", C1)
this joins the contents of cell A1 with B1 and C1, leaving a space between
each one

OR

you can do it this way:

=A1 & " " & B1 & " " & C1

Hope this helps


Cheers
JulieD

 

[Mike]

thanks for the reply...
I'm afraid concatenate doesn't do what I'm trying to describe...
if B1=5 B2=6 C1=7 C2=8, I'd like a column (e.g. A) to be A1=5 A2=6 A3=7 A4=8
etc.
With concatenate, A1= 57, A2= 68 etc.
Any other thoughts?
Thanks for your efforts

 

[Frank Kabel]

Hi
so you want to transfer to multiple columns (B - X starting in row 1)
with only tow rows of data to one column (col. A) with multiple rows.
If yes enter the following in A1:
=OFFSET($B$1,MOD(ROW()-1,1),INT(ROW()-1)/2))
and copy down

 

[Mike]

Thanks for the assist!

Hi
so you want to transfer to multiple columns (B - X starting in row 1)
with only tow rows of data to one column (col. A) with multiple rows.
If yes enter the following in A1:
=OFFSET($B$1,MOD(ROW()-1,1),INT(ROW()-1)/2))
and copy down

 

[Guest]

What I wanna do is combine many cells in only one example
A1, A2, A3, A4...A9 in only 1 cell (A1
thank
Michael

 

[Guest]

Hi
what I want to do is combine several cells in only one for example
A1, A2, A3...A9 in only one cell (A1
thanks
Michael

 

[Guest]

hi
I try to find out how is the procedure to combine cells in only one for example
A1, A2, A3...A9 in only one (A1
thenk
Michea

 

[DDM]

Michael, if all the cells are empty, just select them and Format > Cells >
Alignment > Merge Cells > OK.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com

 

[Guest]

It works as I nee
thanks a lot DD
Michael