One Way,
=VSTACK({"Area","Sales","Extra field to show source"},HSTACK(ExpData1,IF(ExpData1[Area]<>"","ExpData1")),HSTACK(ExpData2,IF(ExpData2[Area]<>"","ExpData2")))