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
How can I add duplicate rows of data based on info in a specific cell in excel?
Maggie C
0
Reputation points
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.
1 answer
Sort by: Most helpful
-
Herbert Seidenberg 1,191 Reputation points
2023-09-05T01:18:22.4+00:00