•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
Our take
Creating a comprehensive store/item list can be a daunting task, especially when you're managing a large volume of data. With approximately 100 items and 5,000 store names, organizing this information into a clear and accessible format is essential. Fortunately, Excel offers powerful tools, such as macros, to streamline this process.
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]
Read on the original site
Open the publisher's page for the full experience