Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When merging information not merging correctly | Excel Worksheet Functions | |||
Linked colums and more | Charts and Charting in Excel | |||
Colums | Charts and Charting in Excel | |||
Sorting, Merging, and Re-merging | Excel Worksheet Functions | |||
Sum YTD Colums | Excel Discussion (Misc queries) |