Skip to Content
0
Former Member
Dec 10, 2009 at 03:30 PM

merge results into single cell to get one line of data

19 Views

Hi,

I am looking to merge several output results <property 1> which have the same common reference numbers <Ref nun> into one cell in order to get one line of data per reference number. The results below are from two data providers and positioned together in the report using sections. The merged dimensions and sections are the Ref number. The Ref num and date are block 1 and the property is block 2.

At the moment I get the following results in three columns:

Ref num....date..........property.....

10.............01/01/09...Laptop.......

..................................Fridge........

..................................Freezer......

11.............02/01/09...Cooker......

12.............02/01/09...Mac...........

..................................Laptop.......

These are the results I want, still in three columns so the property output for each ref number is merged in one cell.

Ref num.....date.........property

10.............01/01/09....Laptop, Fridge, Freezer

11.............02/01/09....Cooker

12..............02/01/09...Mac, Laptop

Is this possible?

Many thanks