•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Duplicate rows in a table for each item in a list
I have a table with product information for 10 items (Sheet 1, A1:D11) that need to be sent to a list of people (Sheet 1, G1:G17). I want to add a column for the people to the table (column E) then duplicate all the product info for each person so the table would show the 10 items for person 1, the same 10 items for person 2, etc.
Is there a nested formula or VBA or something that would do this? I’ve been looking into what I can do with offset or choose rows but fear I’m heading in the wrong direction there.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#financial modeling with spreadsheets
#AI formula generation techniques
#Excel compatibility
#formula generator
#Excel alternatives
#duplicate rows
#product information
#Excel
#VBA
#nested formula
#list of people
#offset
#people
#table
#data duplication
#data manipulation