Summarize column without removing blanks

[samerhajjar]

I have a table with two columns, for the sake of the example they'll be called Name and Date
Below is a sample of that table

Name	Date
a	1/1/2024
a	2/1/2024
a	3/1/2024
b	5/4/2024
b	5/5/2024
c
d
e
f	6/6/2024
f	6/7/2024

I want to show only the Latest Date by Summarizing the column 

But at the same time I don't want to hide the blank rows so my final table should look like this

Name	Date
a	3/1/2024
b	5/5/2024
c
d
e
f	6/7/2024

Any suggestions on how to achieve that will be appricated.

Thank you. 

[Idrissshatila · Accepted solution]

Hello @samerhajjar ,

you add it to a table or matrix and you click on the drop down on the name field and check the show items with no data and the blanks will show.