Column matching problem

[goofer]

Hey all,

Im breaking my head presumably about something quite easy.

I have 2 columns of Dates with corresponding stock prices. Sometimes theres no price for one date that has a price for the other stock.
How do i get one column of dates with corresponding 2 columns of prices. And so filter out dates that lack a price for one of both.

this sounds maybe a lill confusing but I included the sheet in the hope to make it clear Example matching.xlsm

(optional is to also give vba code for this)


Many tnx already

[:) Sixthsense :)]

Referred attached workbook for Pivot Solution. Use Multiple Consolidation Ranges in Pivot.

[goofer]

Thx, but is there no other way than doing this with a pivot table?