What's the best way to merge rows with a common field?

I have a table that has rows that have identical field contents(name, address, zip) except for the last two fields which contain a question and an answer(columns H & J). About every 5 rows the identical data changes (to a new name, address, zip).

I want to create a new table where row 1 has the identical fields (name, address, zip) followed by the non identical information on the same row, H & J(1), H & J(2), H & J(3).

So instead of this:

Mary Jane, 234 Lost Lane, Paris, Tx, Q1, Q2
Mary Jane, 234 Lost Lane, Paris, Tx, Q3, Q4
Mary Jane, 234 Lost Lane, Paris, Tx, Q5, Q6
Mary Jane, 234 Lost Lane, Paris, Tx, Q7, Q8
Mary Jane, 234 Lost Lane, Paris, Tx, Q9, Q10
Joe Smith, 1201 Texas Ave, Justin, Tx, Q1, Q2
Joe Smith, 1201 Texas Ave, Justin, Tx, Q3, Q4
Joe Smith, 1201 Texas Ave, Justin, Tx, Q5, Q6
Joe Smith, 1201 Texas Ave, Justin, Tx, Q7, Q8
Joe Smith, 1201 Texas Ave, Justin, Tx, Q9, Q10

I want this:

Mary Jane, 234 Lost Lane, Paris, Tx, Q1, Q2, Q3, Q4, Q5, Q6, Q7, Q8, Q9, Q10
Joe Smith, 1201 Texas Ave, Justin, Tx, Q1, Q2, Q3, Q4, Q5, Q6, Q7, Q8, Q9, Q10

What is the best way to accomplish for a table of 500+ rows?

One thing to note is that all these rows are in one table so I'm not merging two tables. I'm merging information from 5 rows into 1 and eliminating duplicate information.

I'd love to do this within Excel without having to resort to visual basic programming which I know little about.