Merge duplicates and erase empty lines

[StixStax]

Hey,

I get my data from a databand like this:

Apple
Apple
Apple
Banana
Banana
Banana

if I choose ProcessingDuplicates, i get following result (empty spaces between the lines):

Apple


Banana


How can I merge duplicates and get an output without those blanks?
Expected result:

Apple
Banana

[HighAley]

Hello.

You could add a Group Header with grouping on this column and set the height of the Data Band to 0.
You could read how to create report with Groups in the User Manual.

Thank you.

[StixStax]

Thank you. Exactly what I was looking for.

[Alex K.]

Hello,

We are always glad to help you!
Let us know if you need any additional help.

Thank you.