Forum Discussion
Excel - Expanding Table with Various Results
Hi There, I have sets of data. One being a list of Invoices: Invoice Num, Supplier Name, Amount, Project Code, Work Number, PO Number One being a list of Purchase Orders: PO Num, Supplier Na...
Do not put anything below the formula.
Or put the formula on a seperate sheet with nothing else.
Or put the formula on a seperate sheet with nothing else.
Detlef_Lewin Hi
You see I will initially return all the PO's, but I also need the invoices underneath them?
So that will not work?
- Use VSTACK() to stack both tables.
- Hi,
That will not work either as POs and Invocies have different data so that will not work.- Then do HSTACK().