•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
#row zero
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#store
#item
#list
#Excel
#macro
#manual work
#combination
#data
#column
#row
#addresses
#submission
#store names
#solution
#workflow