•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to Easily Create a Store/Item List
I'm trying to save myself a ton of manual work.
I have ~100 items and ~5000 store names/addresses. I need to create a list that has stores in one column, items in the next column, and each store/item combination listed in its own row. Example:
Row 1: Store 1 || Item 1
Row 2: Store 1 || Item 2
Row 3: Store 1 || Item 3
.....
Row X: Store 5000 || Item 100
Is there a way to do this in excel? Macro maybe?
Thank you in advance!!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com