SHL
Executive Member
- Joined
- Dec 17, 2012
- Messages
- 6,172
- Reaction score
- 11,220
For the excel experts, below is an example of a spreadsheet I extract on a monthly basis. The problem is that each shop name appears only once in the same column as the sold products.
What formula can I use to get the store name to appear next to each of the sold products as below?
| Description | QOH | Sold |
| TOTALS | ||
| SHOP W | ||
| Product F | 6 | 4 |
| Product G | 0 | 17 |
| Product H | 0 | 10 |
| Product I | 0 | 1 |
| Product J | 7 | 13 |
| TOTALS | 13 | 45 |
| SHOP X | ||
| Product A | 10 | 14 |
| Product B | 0 | 17 |
| Product C | 4 | 2 |
| Product D | 3 | 4 |
| TOTALS | 17 | 37 |
What formula can I use to get the store name to appear next to each of the sold products as below?
| Description | QOH | Sold | |
| SHOP W | SHOP W | ||
| SHOP W | Product F | 6 | 4 |
| SHOP W | Product G | 0 | 17 |
| SHOP W | Product H | 0 | 10 |
| SHOP W | Product I | 0 | 1 |
| SHOP W | Product J | 7 | 13 |
| SHOP W | TOTALS | 13 | 45 |
| SHOP X | SHOP X | ||
| SHOP X | Product A | 10 | 14 |
| SHOP X | Product B | 0 | 17 |
| SHOP X | Product C | 4 | 2 |
| SHOP X | Product D | 3 | 4 |
| SHOP X | TOTALS | 17 | 37 |
Last edited: