Merge 4 tables in Excel.

[vrunda]

Hello!
I have data in 4 tables with identical column headers with date, amount & text in 3rd column.
I tried many ways to combine it but date column & text column does not get merged.
Any solution. Text column contains word either "CASH" or :CHEQUE".

 

[Somendra Misra]

Hi vrunda,

A sample file with table structure with few lines of data and output can fetch you more results.

Regards,

 

[pecoflyer]

see http://www.rondebruin.nl/win/addins/rdbmerge.htm

 

[vrunda]

find file attached.
It will be very good if VBA solution is avoided.

 

[vrunda]

hello pecoflyer,
Thanks for replying so quickly , but i installed it and unable to use it correctly. Thanks once again.

 

[Deepak]

Hi,

Loop this.

http://www.contextures.com/xlPivot08.html

 

[azumi]

Solution with formula, but not sure with your real workbook, just for sample workbook

CHeers

 

[vrunda]

Thanks Deepak , I saw that site before posting here the question but as said for dates and text it does not work. How to write MS query I dont know -- in Excel 2010. I think MS query would solve it. Consolidation is also not working.....

 

[vrunda]

Azumi, You formula is working in sample sheet , i shall try in real data .
Is there solution to combine 4 Pivot tables.