Merging Colums
If you have
1 2 3
or
1 3
or
2 3
or
3
And can end up with
123
13
23
3
you could use a formula like:
=a1&b1&c1
or
=if(a1<"",a1," ")&if(b1<"",b1," ")&if(c1<"",c1," ")
to end up with
123
1 3
23
3
I'm not sure what you want.
=if(a1<"
Spatzz wrote:
Dave,
thanks.That has helped in me recoding the Y's. Any ideas how i can merge the
data in the resulting three columns in to 1?
"Dave Peterson" wrote:
Select each column (one at a time)
edit|replace
what: y
with: 1 (or 2 or 3 ...)
replace all
=======
Or you could try this.
Select your range to change
edit|replace
what: y
with: =column()
replace all
If column1 is not A, you may have to use a formula like:
=column()-3
(if I was starting in column D)
Spatzz wrote:
Hi i have a sheet with data in the following format
Column1 Column2 Column3 etc
Y
Y
Y
I need to changed the Y's to different values. In column1 Y needs to equal =
1 and in Y in column2 needs to equal 2 etc. Is it possible to change the
values other than having to change each Y indvidually? I have 700 rows!!!
I then need to merge the three rows so i have one column with the converted
data.
I'm new to excel and and can not see away through.
Help
--
Dave Peterson
--
Dave Peterson
|