Hello, I need help coming up with a formula to combine two or more tables of data into a single table. In the example below, I want to combine the rows of tables A and B together into a single table, while filtering out the rows that are blank entirely and those rows with a zero value of "Amount". Knowing how to sort by a particular column would be good too. I know how to do all this in google sheets with a query command, but I don't know how in excel and I don't have any SQL skills. Can I accomplish this in a single formula??? Thanks for the help. Max
A Dept Project Account Amount B Dept Project Account Amount
100 20 0 1 56 110 20 0 2 12
101 40 0 2 0 110 40 0 3 34
102 60 0 3 78 111 60 0 4 0
103 80 0 4 34 112 80 0 5 67
104 100 0 5 0 113 100 0 6 78
105 120 0 6 6 114 120 0 7 0
106 140 0 7 12 115 140 0 8 23
Bookmarks