Dear All,
I would like to repeat the SKU number(vertically) based on the qty of the SKU.
I am trying to create a template where there will be an input field and an output field(Desired Result).
In the input field, there will be SKU & their corresponding qty. The qty range would vary between 1 to 100 maximum. At a time a maximum of 600 SKU will be entered in the input field along with their corresponding qty.
The formula in the desired column should repeat the SKU number vertically, that many times as that of the qty. Also the range will be continuous and there would be no gap between 2 SKUs.
For example, I have a small data set where I have got 4 different SKUs and their corresponding Qty across A1:B6.
The formula in the Desired columnD, should repeat the SKUs multiple times based on the qty mentioned against the SKUs.
The SKU no:-122001 should be repeated twice under the D column followed by article 134569(thrice),followed by article 178906(10 times) & 187652(5 times).
Could somebody help me out with the formula in Column D which can yield the desired result?
Thanks in advance.
Sheet1
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:93px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
I would like to repeat the SKU number(vertically) based on the qty of the SKU.
I am trying to create a template where there will be an input field and an output field(Desired Result).
In the input field, there will be SKU & their corresponding qty. The qty range would vary between 1 to 100 maximum. At a time a maximum of 600 SKU will be entered in the input field along with their corresponding qty.
The formula in the desired column should repeat the SKU number vertically, that many times as that of the qty. Also the range will be continuous and there would be no gap between 2 SKUs.
For example, I have a small data set where I have got 4 different SKUs and their corresponding Qty across A1:B6.
The formula in the Desired columnD, should repeat the SKUs multiple times based on the qty mentioned against the SKUs.
The SKU no:-122001 should be repeated twice under the D column followed by article 134569(thrice),followed by article 178906(10 times) & 187652(5 times).
Could somebody help me out with the formula in Column D which can yield the desired result?
Thanks in advance.
Sheet1
* | A | B | C | D |
1 | Input Field | * | Desired Result | |
2 | SKU | Qty | * | SKU |
3 | 122001 | 2 | * | 122001 |
4 | 134569 | 3 | * | 122001 |
5 | 178906 | 10 | * | 134569 |
6 | 187652 | 5 | * | 134569 |
7 | * | * | * | 134569 |
8 | * | * | * | 178906 |
9 | * | * | * | 178906 |
10 | * | * | * | 178906 |
11 | * | * | * | 178906 |
12 | * | * | * | 178906 |
13 | * | * | * | 178906 |
14 | * | * | * | 178906 |
15 | * | * | * | 178906 |
16 | * | * | * | 178906 |
17 | * | * | * | 178906 |
18 | * | * | * | 187652 |
19 | * | * | * | 187652 |
20 | * | * | * | 187652 |
21 | * | * | * | 187652 |
22 | * | * | * | 187652 |
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:93px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4