Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting/Moving Data
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving a line chart data point revises data table value in Excel ' | Charts and Charting in Excel | |||
Moving Cell Reference after Sorting | New Users to Excel | |||
moving data to non autofarmatted book changes data- Why? | Excel Discussion (Misc queries) | |||
Sorting/Moving | Excel Discussion (Misc queries) | |||
moving data in excel without deleting existing data | Excel Discussion (Misc queries) |