List with 4 columns display employee number and health component. one employee has multiple health components how to only get one row and not 3 for the same employee? i removed the health component which was the only column that was different for that employee. The other 3 columns are the same so i want to do like a distinct.
example
employee id, employee name, value
12, test, 5
12, test, 5
12, test, 5
instead of 3 rows for the same employee i only want one.
