Hi - I'm new to this forum and hoping for some help. I work for a law enforcement agency and I receive a data set created by law enforcement software that I need to transform.
The data conundrum explanation is a bit lengthy, so bear with me! In this example, it is use of force data. The software creates multiple rows of data related to the same incident for different force options used and injuries to officers/citizen (27 force options, 6 officer injury options, 10 citizen injury options). So if an officer uses a strike and a kick, it results in 2 rows of data. I need to convert this to 1 row (= 1 incident) and each of the different force/injury options need to be in a new column to cover all the different possible variations.
In the attached, columns K, O, and P create multiple rows.
Example - Rows 4 & 5
Column A: UOF19-005 Column K: Take Down
Column A: UOF19-005 Column K: Compliance Hold
Need it as:
Column A: UOF19-005 Column K: Take Down + New Column: Compliance Hold
(and deleting the duplicate row)
Bookmarks