If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Merging Colums
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 |
#2
|
|||
|
|||
Merging Colums
Do you actually want to change the cell contents to numbers, or do you just
wish to total the values that each column represents? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Spatzz" wrote in message ... 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 |
#3
|
|||
|
|||
Merging Colums
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 |
#4
|
|||
|
|||
Merging Colums
Ragdyer,
thanks for getting back. I do need to change the cell contents. I'm trying to recode so i can them move the data in to SPSS. I've changed the Y's as suggested by Dave using edit replace. Any ideas how i can merge the resulting three columns in to one? "Ragdyer" wrote: Do you actually want to change the cell contents to numbers, or do you just wish to total the values that each column represents? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Spatzz" wrote in message ... 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 |
#5
|
|||
|
|||
Merging Colums
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
Merging Colums
You should always give before/after examples so we understand what you want.
IF? I understand what you want, this will copy the last column in any row to column 1. Then just delete or clear all other columns. Sub Makeonecolumn() For i = 1 To 7 'change 7 to suit rows needed Cells(i, 1) = Cells(i, "iv").End(xlToLeft) Next i End Sub -- Don Guillett SalesAid Software "Spatzz" wrote in message ... 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 |
#8
|
|||
|
|||
Merging Colums
F5SpecialBlanks.
EditDeleteShift cells left. Gord Dibben MS Excel MVP On Sat, 19 May 2007 01:56:02 -0700, 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 |
#9
|
|||
|
|||
Merging Colums
I think Gord's idea is the easiest.
-- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "Spatzz" wrote in message ... Ragdyer, thanks for getting back. I do need to change the cell contents. I'm trying to recode so i can them move the data in to SPSS. I've changed the Y's as suggested by Dave using edit replace. Any ideas how i can merge the resulting three columns in to one? "Ragdyer" wrote: Do you actually want to change the cell contents to numbers, or do you just wish to total the values that each column represents? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Spatzz" wrote in message ... 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 |
#10
|
|||
|
|||
Merging Colums
Ahhhh.
To the OP: This will work nicely if the options are mutually exclusive. But if you have any rows that have multiple "responses", then it may not do what you want. Another way if they're mutually exclusive: =sum(a1:C1) convert to values and delete the original columns. Gord Dibben wrote: F5SpecialBlanks. EditDeleteShift cells left. Gord Dibben MS Excel MVP On Sat, 19 May 2007 01:56:02 -0700, 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 |
|
Thread Tools | |
Display Modes | |
|
|