Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have 2 columns with "1's" used to indicate a checkmark in that column. I
want to move the data from one column (eg column A) to another column (eg column b) to consolidate the data into the one column (column b). This looks like this: A B into B 1 1 1 1 1 1 1 1 1 1 I would then be able to sum the numbers in column B to get a new total that is the total of the old A and B. Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
combine column data | Excel Discussion (Misc queries) | |||
how to combine data from Column A & B | Excel Discussion (Misc queries) | |||
How can I combine multiple columns of data into 1 column? | New Users to Excel | |||
Combine 2 spreadsheets w/1 common column of data, text and number | Excel Worksheet Functions | |||
How to combine data from two columns into one column? | Excel Worksheet Functions |