1 min readfrom 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!!

submitted by /u/Vendettassss
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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