I have created a report containing a subreport.  The main report looks up bookings travelling on a certain date, the subreport returns any travel notes for each booking.  I then export this to excel, the problem is that the values returned from the subreport are entered in a separate row in excel, and I need the values to be merged together in one cell

 

For example the report returns the following:

 

Ref         NOTES

X1234    vegetarian

              aisle seat required

 

What I need is