|
|
|
|
#1
01-05-2016, 01:19 PM
|
|||
|
|||
I may have found an answer to combining 2 columns. Looks like I need to tweak the following because I have column headers so I need to get this command to start at row 2. It almost works as is.
=IF(ROW()<=COUNTA(A:A), INDEX(A:A,ROW()), IF(ROW()>COUNTA(A:B), "", INDEX(B:B,ROW()-COUNTA(A:A)))) 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Excel, transfer data from Master Sheet to sub sheets, using key word from column
|
anvqui | Excel Programming | 9 | 06-16-2015 01:35 PM |
| Need help in automating data from multiple sheets into a single sheet | veedee | Excel Programming | 8 | 06-12-2014 10:04 PM |
|
Need help in automating data from multiple sheets into a single sheet
|
veedee | Excel | 1 | 06-11-2014 04:01 AM |
| Combine Data From 2 Sheets into a new sheet | bremen22 | Excel | 1 | 09-11-2013 12:59 PM |
|
How do I merge data from one sheet in a workbook out into multiple sheets
|
nolesca | Excel | 4 | 06-07-2010 08:13 AM |
Windows 7 64bit 
Office 2013
Hybrid Mode