I have a data set with Event IDs and the activities associated with the event, sorted by Event ID + timestamp in ascending order. I am trying to do a groupconcat to get all the activities within that Event ID in a list which is sequential and aligns with the order of activities which took place. However despite ordering the source sheet, the groupconcat sheet does not concatenate the results in sequential order. Does anyone know a workaround for this?
Please sign in to leave a comment.