I have an Excel worksheet with many rows of data I that I will need to
sort/anyalyze. The data is from accident reports and has columns with
information about the accident (location, weather, speed, injury, vehicle
type). If mulitple vehicle were involved in the accident, it lists
information for the second vehicle in the next row. The information it shows
for the second vehicle is only a partial row of data (speed, injury, and
vehicle type, it does not repeat info such as location and weather).
However, I need to move the information about the second vehicle to the
previous row, next to the first vehicle. I am dealing with a large amount of
data (sometimes 1500 rows). Is there a way to automate this process to move
the information. Also depending on the accident, sometimes there is more
than one vehicle involved, so there is no set pattern to the worksheet.
(i.e. full info row, partial info row, full info row, partial row, etc.) I
understand this may not be the clearest explanation and if you need
clarification of my question, please feel free to ask. I sincerely
appreciate feedback that anyone can provide. Thank you.