SQL Server Replication, Consolidation

How do I consolidate multiple publications into 1 consolidated table on the subscriber? For example. Consider a very simple sales model where 开发者_如何学JAVAwe replicate sales data from the stores to the central office.

Store 1 Sales Table  
=====================  
Item     Qty      Amt  
=====================  
111       2     10.00  
222       1      7.00  
333       1     12.00  

Store 2 Sales Table
=====================
Item     Qty      Amt
=====================
111       2     18.00
222       1     13.00
333       1      4.00

How do I replicate these two sales publications from the publisher to ONE consolidated sales table at the subscriber:

Central Office
==============================
Store   Item     Qty       Amt
==============================
1        111       2     10.00
1        222       1      7.00
1        333       1     12.00
2        111       2     18.00
2        222       1     13.00
2        333       1      4.00

---

Use "Keep the existing table unchanged", default is drop and recreate.

Fast search, old example but seems valid -> sql preformance