--- a/displayConsultancies.php
+++ b/displayConsultancies.php
@@ -11,7 +11,7 @@
 
 include_header("Consultancies");
 $query = '
-SELECT SUM(value) as value, count(*), min("supplierName"), unnest(string_to_array("consultancyReason",\';\')) reason
+SELECT SUM(value) as value, count(*), text_mode("supplierName"), unnest(string_to_array("consultancyReason",\';\')) reason
 FROM contractnotice where ' .$yearQ . ' "consultancy" = \'Yes\' and "childCN" is null
 GROUP BY "supplierABN",reason order by value desc
  ';