Required Excel VBA expert

Job ID: 33353560

Budget: ₹400 – ₹750 INR

I have an excel sheet, Where in Col A multiple IDs are there, and in Column, each has unique ticket nos.
I want all tickets not should come in a single row with one participant's id. This is a simple task for any VBA expert person.