General Question adding additional Values to the Column

[its_rajvir]

Dear Experts,

I really need your help in solving one problem 😑. Please see the attached photo for the Query. If it's not too much trouble, could someone please share their insights or suggestions on how to solve this? I truly value your input and time.

[Anil_Babu_Samineni]

@its_rajvir Is that if you can share Table1 and Table2 in excel? So that we can have a look

[its_rajvir]

Hi @Anil_Babu_Samineni  Thank you very much for the Reply. I attached the excel file with Table 1 and 2.

[Anil_Babu_Samineni]

@its_rajvir Great, thanks for that. i have couple of questions for you.

1) If we talk Output table for PlaceID (Ex, 101) for both Enter and Exit (How, 16689 and 16433)?

2) For missing 105, 109 - Can we know the logic why they start from B6-(xxxx)?