merge columns cells with duplicated value

[sadiq92]

Hello

I have a report that shows to me the following table :


Company Name Vehicle Number License Date of License

A 2525 25/2/2024
A 6541 26/4/2024
A 6854 24/4/2024
B 4854 06/8/2024
B 6854 04/9/2024
B 8472 06/4/2024


I want a merge of cells under (company name) columns that have duplicated values , so I want the report to be as following:

Company Name Vehicle Number License Date of License

A 2525 25/2/2024
6541 26/4/2024
6854 24/4/2024
B 4854 06/8/2024
6854 04/9/2024
8472 06/4/2024


Is it possible?

 

[The_Doc_Man]

1. Yes, should be possible. What you are describing should easily be managed by the report Sorting and Grouping option.

2. You posted the same question twice about 5 minutes apart. One of them was redundant so in my capacity as a moderator, I removed it.

 

[Gasman]

Look at Hide Duplicates in the Format tab of the control.