I have data set that contains a order number and the order steps that show what each order went through before being processed. I would like to be able to have the step field in one line per order. In my example screenshot the OBJNR is the order number and STAT is the step column. It’s one order but in the dataset it’s broken out into multiple lines and I’m hoping there is a way to put it all in one row.
I have to join this dataset to another on order number but because of the way it’s structured it’s creating a one to many join and bringing back duplicate measure values.