Dear Christian, thank you v.much for your efforts.

regarding your comments , i am able to add the first Name column as field but i highlighted that to allow you to add in in the [Pax in the same PNR#] which i couldn't make it with both names.

I am working for airline , but unfortunately the data i have is limited to what i have given you. there is no much fields that could allow me to filter my data except what i have , i want to generate report that shows all the data of each passenger in one row , but some cases i can't because the result will be not correct for the round trip flights where the departure city and arrival city will be the same for example if passenger traveling CAIRO - PARIS - CAIRO , If i used the same condition the result will be he traveled from Cairo to Cairo and the transit city was Paris.. which is confusing output.

so thats why i am having those scenarios in parts.

I hope that some one could help me in this.

thank you and B. Regards

Alhakimi