How can I filter or summarize a text field in a portal?

Version 1

    HI!

     

    I have a self join relationship table to create a portal in my layout. but I don't know how to summarize or sub summarize a text field so it will appear only one record each category will show. Anyone can help please.

     

    Table1        Table 2

    Supplier = SupplierJustone.jpg