How can I add duplicate rows of data based on info in a specific cell in excel?

Maggie C 0 Reputation points
2023-08-31T23:46:43.73+00:00

I am trying to create duplicate records in excel based on the data in a specific column. The data has one unique identifier per record but multiple models can apply to the identifier. I want to copy and duplicate the record if there are multiple models noted and show only one model in the new reference noted. I added a screenshot of an example of the data and the output I'd like to see. The actual data set is much larger and I'd ideally like to see the ouput on a separate tab. I believe this may be accomplished through VBA though I am not sure the code to do so.

User's image

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
930 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,520 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Herbert Seidenberg 1,191 Reputation points
    2023-09-05T01:18:22.4+00:00

    Excel 365 Pro Plus with Power Query.
    Duplicate record if adjacent cell has multiple values.
    No formulas, no VBA macro.
    https://www.mediafire.com/file_premium/xmqe7738isljwct/09_04_23.xlsx/file
    https://www.mediafire.com/file_premium/5bfm6tjbud9ekk4/09_04_23.pdf/file

    0 comments No comments