Merge two tables in one table

**shimaa01234** · 10-05-2014, 10:20 AM

I want to merge these two tables, in one table as it exists in the example

**alansidman** · 10-05-2014, 11:22 AM

Why not just copy Sheet 2 and paste it to the bottom of sheet 1?

**Vikas_Gautam** · 10-05-2014, 11:34 AM

Hi,
What do you really want ....?
Do you want a macro to do this automatically....?
or
may be your original dataset is much bigger..

**shimaa01234** · 10-05-2014, 11:38 AM

Actually tables contain many data
Is it possible to do so by the formula
I use Office 2003

**Vikas_Gautam** · 10-05-2014, 12:33 PM

Yeah it is possible..
For 2003

Formula:

=IF(ISERROR(INDEX($A$2:$D$14,ROW($A1),COLUMN(D$1))),INDEX($H$2:$K$14,ROW($A1)-ROWS($D$2:$D$14),COLUMN(D$1)),INDEX($A$2:$D$14,ROW($A1),COLUMN(D$1)))

The length can be more better if you use Excel 2007 or more..
Check the attached file..

**shimaa01234** · 10-05-2014, 04:33 PM

Your solution wonderful and beautiful
Thank you very much Mr. "Vikas Gautam"

**Vikas_Gautam** · 10-05-2014, 11:09 PM

Thanks for the response....

**shimaa01234** · 10-06-2014, 03:43 AM

Last request
Is it possible to integrate These tables also
Thank you very much for the first solution

Re: Merge two tables in one table