Not sure how to describe this.
Say I have one file that contains a list of stores.
Another file that contains product.
I need to combine the two, so that the product duplicates below each of the stores.
With the store being it's own row.
So it's like a cross between a Union and Append tool.
Store - Input 1
Store1_NAME
Store2_NAME
Store3_NAME
Store4_NAME
Product - Input 2 (this is already a CSV file)
123*Orange*16
234*Blue*02
345*Red*32
Would look like this:
Store1_NAME
123*Orange*16
234*Blue*02
345*Red*32
Store2_NAME
123*Orange*16
234*Blue*02
345*Red*32
Store3_NAME
123*Orange*16
234*Blue*02
345*Red*32
Store4_NAME
123*Orange*16
234*Blue*02
345*Red*32
解決済! 解決策の投稿を見る。
Hi @Number4
I made a quick batch macro that unions the products to each store. I'm curious to see other approaches, this might be overkill but to me is the simplest answer.
Hi @Number4 ,
I've built a little macro to do this for you:
This takes the Store as a control parameter and loops through, applying the Products to each store. Careful to sum in case there are any repeated store values.
M.
Thanks @Luke_C! Worked great.
Thanks @mceleavey it looks like both responses derived the same result.