Results 1 to 16 of 16

Transform multiple rows from same record to one row with additional columns for variables

Threaded View

Coloradolady65 Transform multiple rows from... 01-07-2021, 06:25 PM
alansidman Re: Transform multiple rows... 01-07-2021, 06:55 PM
Coloradolady65 Re: Transform multiple rows... 01-07-2021, 07:03 PM
alansidman Re: Transform multiple rows... 01-07-2021, 07:14 PM
Coloradolady65 Re: Transform multiple rows... 01-07-2021, 07:25 PM
alansidman Re: Transform multiple rows... 01-07-2021, 07:44 PM
Coloradolady65 Re: Transform multiple rows... 01-07-2021, 07:48 PM
alansidman Re: Transform multiple rows... 01-07-2021, 07:50 PM
Coloradolady65 Re: Transform multiple rows... 01-08-2021, 04:09 PM
alansidman Re: Transform multiple rows... 01-08-2021, 04:36 PM
Coloradolady65 Re: Transform multiple rows... 01-08-2021, 04:51 PM
alansidman Re: Transform multiple rows... 01-08-2021, 05:59 PM
Coloradolady65 Re: Transform multiple rows... 01-08-2021, 06:30 PM
Coloradolady65 Re: Transform multiple rows... 01-14-2021, 06:05 PM
alansidman Re: Transform multiple rows... 01-14-2021, 06:21 PM
alansidman Re: Transform multiple rows... 01-15-2021, 12:27 PM
  1. #1
    Registered User
    Join Date
    01-07-2021
    Location
    Colorado Spring
    MS-Off Ver
    2013
    Posts
    8

    Transform multiple rows from same record to one row with additional columns for variables

    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)
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Combining One Record w Multiple Rows into One Row Multiple Columns
    By IXLADXI in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-22-2018, 05:35 AM
  2. Transform to multiple rows
    By Taangh in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-30-2016, 07:00 AM
  3. Text to rows and not columns when you have multiple variables
    By sharma06shubham in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-05-2016, 01:23 AM
  4. Replies: 14
    Last Post: 10-07-2013, 04:04 PM
  5. best way to record multiple variables before use in pivot table
    By masterintraining in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-14-2012, 03:02 PM
  6. Turning Multiple Columns for a Record Into Multiple Rows
    By BeeZeRCoX in forum Excel General
    Replies: 4
    Last Post: 08-16-2012, 02:12 AM
  7. Transform Duplicate rows to columns
    By Ray789 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-04-2011, 02:56 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1