HI
I have been trying to group data, not like grouping under the Data Tab or Analyse, but take a list and group in this case by the 1st and 2nd column, but not keep repeating the value down the list values.
Included are 2 images, 1st is the data, 2nd is how i would like the output to look.
Essentially grouping on 1st and 2nd column and listing the 3rd column
Many thanks for any advice
Chris
I have been trying to group data, not like grouping under the Data Tab or Analyse, but take a list and group in this case by the 1st and 2nd column, but not keep repeating the value down the list values.
Included are 2 images, 1st is the data, 2nd is how i would like the output to look.
Essentially grouping on 1st and 2nd column and listing the 3rd column
Many thanks for any advice
Chris