Help with combining data from different sheets

Brass Contributor

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]),""))