Combine rows based on *

[ZahinOsman]

Hi all,

I have 2 excel tables in 2 different sheets;

Table A

Trade ID	Book_Nm	Book CD	Sap Company CD	Country CD	Country Nm	Trade Mnth	Date.Period
1234	Bear	Gumbo	5279	SG	Singapore	2023-03	3/8/2022	*
1234	Apple	Gumbo	5279	SG	Singapore	2023-03	3/8/2022
1234	Solid	Gumbo	5279	SG	Singapore	2023-03	3/8/2022	*
1234	Done	Gumbo	5279	SG	Singapore	2023-03	3/8/2022

Table B

Trade ID	Book_Nm	Book CD	Sap Company CD	Country CD	Country Nm	Trade Mnth	Date.Period
1234567	Cheese	Mama	5279	SG	Singapore	2023-03	3/8/2022
1234567	Cheese	Mama	6790	SG	Singapore	2023-03	3/8/2022
1234567	Cheese	Mama	5279	SG	Singapore	2023-03	3/8/2022
1234567	Cheese	Mama	6790	SG	Singapore	2023-03	3/8/2022
57823	Brie	Papa	5670	SG	Singapore	2023-03	3/8/2022

How do I combine the rows marked with * with table B? It should look like something below to form Table C;

Table C

Trade ID	Book_Nm	Book CD	Sap Company CD	Country CD	Country Nm	Trade Mnth	Date.Period
1234567	Cheese	Mama	5279	SG	Singapore	2023-03	3/8/2022
1234567	Cheese	Mama	6790	SG	Singapore	2023-03	3/8/2022
1234567	Cheese	Mama	5279	SG	Singapore	2023-03	3/8/2022
1234567	Cheese	Mama	6790	SG	Singapore	2023-03	3/8/2022
57823	Brie	Papa	5670	SG	Singapore	2023-03	3/8/2022
1234	Bear	Gumbo	5279	SG	Singapore	2023-03	3/8/2022
1234	Solid	Gumbo	5279	SG	Singapore	2023-03	3/8/2022

Appreciate the help!

[Hammad_Rashid]

 

1. Load Data

2. Filter Rows in Table A:

   • Use the Filter tool to filter the rows in Table A where the condition is met (the rows marked with *).

3. Union:

   • Use the Union tool to combine the filtered rows from Table A with Table B. Connect the output of the Filter tool to one input of the Union tool and Table B to the other input.

4. Output