Marco to find desired missing data

[k3pineapple]

HI team,

Looking for a flow/Macro that can generate output

To Generate missing product for all users. Many Thx

Input

Company	Branch	Product	Code	Status	Login	Count
ABC	A	A	123A	Enabled	A123	2
ABC	A	B	123A	Enabled	A123	2
ABC	A	A	123A	Enabled	B123	1
ABC	B	A	123A	Enabled	C123	2
ABC	B	C	123A	Enabled	C123	2
DEF	A	A	456B	Enabled	D123	2
DEF	A	C	456B	Enabled	D123	2
DEF	B	C	456B	Enabled	E123	1

Output

Company	Branch	Product	Code	Status	Login
ABC	A	C	123A	Enabled	A123
ABC	A	B	123A	Enabled	B123
ABC	A	C	123A	Enabled	B123
ABC	B	B	123A	Enabled	C123
DEF	A	B	456B	Enabled	D123
DEF	B	A	456B	Enabled	E123
DEF	B	B	456B	Enabled	E123

[Raj]

@k3pineapple 
can you please explain the logic

[Verakso · Accepted solution]

Perhaps something like this?

Br (ツ)

Thomas

[jdminton]

@k3pineapple  I don't think you've provided enough information. Also, your data generalization is probably going to cause problems. For example, I doubt that the same branches exist in different companies. Also, there is no way for us to know if status, code, or count are relevant for this. Can you clean up the sample data and provide more information on what you're needing?

[Raj]

@k3pineapple 
is this solved?

if not please share the logic for this.

[k3pineapple]

@Raj above flow works

[k3pineapple]

Appreicated