Combine data from multiple rows into a single row

Hi Jilly

My take on your query is that you need to create a second reporting worksheet that combines the data in your first sheet.  That way, your original data is able to be added to from your original database in the form you are importing it, and you just switch over to the report worksheet to see the information displayed as you want it. 

I would add a helper column to the right of the data in the data sheet as column E with the following formula

=IF(A2<>A1,B2,E1&" , "&B2)

In the reporting sheet, list the report numbers in column A, and in column B type the formula

=INDEX(Sheet1!$E$1:$E$200,MATCH($A1+1,Sheet1!$A$1:$A$200,0)-1,1) 

You can add more columns as you need to capture other data if required