i think you understood my requirement corrrectly.

there are two tables

image 1:shows input

image 2 :output.

Hi Thanks for your reply,

i'm trying to combine rows with same last name and first name.

Thanks

Anjee