Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining one row into two
Hello,
Is there a way to combine row A and B into one row? For example, I have data in both rows, both numeric and words. Both rows are for the same borrower. I am trying to combine row A and B into one row that has all the data both A and B had. I know I can cut and paste each line, but the spreadsheet is large. Any ideas? Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining one row into two
I notice that your question was answered in your earlier post. You
could follow-up there if you need more guidance. On Jul 12, 3:32 pm, nabanco wrote: Hello, Is there a way to combine row A and B into one row? For example, I have data in both rows, both numeric and words. Both rows are for the same borrower. I am trying to combine row A and B into one row that has all the data both A and B had. I know I can cut and paste each line, but the spreadsheet is large. Any ideas? Thank you |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining one row into two
Thu, 12 Jul 2007 12:32:01 -0700 from nabanco
: Is there a way to combine row A and B into one row? For example, I have data in both rows, both numeric and words. Both rows are for the same borrower. I am trying to combine row A and B into one row that has all the data both A and B had. In C1, put =A1&B1 then click and drag to the rest of C. (By the way, A and B are columns, not rows.) -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining second row to first row | Excel Discussion (Misc queries) | |||
Combining | Charts and Charting in Excel | |||
Combining look up and last? | Excel Discussion (Misc queries) | |||
Combining Sum, IF and AND | Excel Discussion (Misc queries) | |||
combining IF and AND | Excel Discussion (Misc queries) |