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 “app’s input data” and third is settlement-income”.
In the “app’s input data” tab I have the following column headings.
DEAL ID | State | Created Date | CP ID | Channel Partner | Amount | Status | EE/SE |
In the tab “settlement-income” I have.
DEAL ID | Settlement Date | CP ID | Channel Partner | State | TAF |
I want to be able to combine some of the data from the 2nd and third sheet into the Output sheet.
The columns I want are:
Deal ID
CP ID
Channel Partner
TAF
Status.
I have tried vstack with choosecols but cannot seem to get it to work.
Am I using the right approach or is there a better way to achieve what I want.?
Appreciate your assistance in advance.
Rob
1 Reply
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]),""))
