Want to insert new column if condition match

[Jeeru_venkat_Rao]

Hello Experts,

Bot should go through each player one by one and check if value “x” mentioned in whole date range if yes then skip that record otherwise bot should enter same record again in bottom with same details for A to C column then in date range it should mention value “x” for all columns for same person and for other person it should mention same data. Please see screenshot for your reference.
![The image shows a table of WWE data listing player names, authorized doctors, diseases, and daily records from January 1st to January 7th, highlighting consultations (R) and prescription drugs (BC) in yellow.
Actual data-

Required data

If anyone want excel data pls let me know.
Please help me in this challenge

[SorenB (Søren Schytz Birk)]

Hello Jeeru

Are you able to rephrase your description?
Im afraid I fail to understand excactly what your are trying to accomplish.

Bot should go through each player one by one and check if value “x” mentioned in whole date range if yes then skip that record

“John Cena” has “R” in first column but is still skipped?

Regards
Soren

[Jeeru_venkat_Rao]

@SorenB , Bro I apologies that is x,

Query - Bot should check value x is availabe for whole date range then skip the record else it insert new record.
If you see in 1st screenshot player 2- Randy Orton there are BC and X values available for both JOHN SMITH & ROSE MARY.
What I need is bot should put x in ROSE MARY in top record and enter new record and put X in JOHN SMITH and placed same value in Rose mary

See in 2nd screenshot.
I hope you understand now

[Sagar1 (Sagar Das)]

Hi @Jeeru_venkat_Rao ,

please provide your input file sample copy.

[Jeeru_venkat_Rao]

Sure, I will.

I almost crack but still stuck in one place.
See below screenshot

Here 3 players visited both physcians(Smith & Mary) on different dates, if a player visited both physcians then there should be 2 entries and if only visited 1 physician then skip that record.
In below screenshot we can see player 1 visited both physicians so 2 entries and other players visited only 1 physician.

I hope you understand my query.

2nd query–> I want total count of visit for physican for per player
For eg. Chris jericho-- Smith->1 & Mary->2

3rd query-> want unique count of physicans. Like in this case is 2.

Try to solve these interesting queries.
Book1.xlsx (12.9 KB)