I have an excel sheet that has a number of entities that are defined by their 'Job Number'. However, I need multiple rows per job meaning that the column ends up having duplicates, such as in
Is there a way to combine each group of identical job number so that they are a 'single' row? is what the preferred layout is.
Note: Each job is guaranteed to be 3 rows, so it will always follow the same pattern. Is there a way to do this?