Good day to all you excel gurus.
I have come across this problem at work and need assistance.
Please be kind enough to move the thread to any relevant sub if i'm posting it in the wrong place.![]()
I have an excel workbook with one sheet that has data as following
Code Name Shelf Stock Cluster 97 Item 1 14 XL 98 Item 2 15 XL 99 Item 3 5 XL 100 Item 4 18 XL
To explain you the scenario, this table contains the order quantities for a list of items for a collection of outlets called a cluster. In a cluster there might be 4 outlets. So this document is shared between 4 different sites.
The list of outlets in the 'XL' cluster is as following: SCCC, SCUP, SCMG, SCCM.
What i want to do is this:
Code Name Shelf Stock Cluster 97 Item 1 14 SCCC 98 Item 2 15 SCCC 99 Item 3 5 SCCC 100 Item 4 18 SCCC 97 Item 1 14 SCUP 98 Item 2 15 SCUP 99 Item 3 5 SCUP 100 Item 4 18 SCUP 97 Item 1 14 SCCM 98 Item 2 15 SCCM 99 Item 3 5 SCCM 100 Item 4 18 SCCM 97 Item 1 14 SCMG 98 Item 2 15 SCMG 99 Item 3 5 SCMG 100 Item 4 18 SCMG
I want to basically duplicate the range for n times (number of outlets in the cluster) but each time the range is duplicated, i want the cells in the "Cluster" column to be replaced with the outlet code.
Currently i do this manually but it's very time consuming since there's 7 clusters and 70+ sites.
Is there a way to automate this scenario?
Thanks in advance!
Nick~
Bookmarks