Forum Discussion
Help with combining data from different sheets
Hi, I am hoping someone is able to assist me with how to combine data in one sheet from other sheets within a workbook. In the attached spreadsheet the first tab is called “output”, second one is...
robwill100 You need to re-shape data first then stack from those two sheet. Try-
=VSTACK(IFERROR(HSTACK(Input_Data[Deal ID],"",Input_Data[CP ID],Input_Data[Channel Partner],""),""),
IFERROR(HSTACK(Settlements_FY21_23[DEAL ID],Settlements_FY21_23[Settlement Date],Settlements_FY21_23[CP ID],Settlements_FY21_23[Channel Partner],Settlements_FY21_23[TAF]),""))