matt121237
New Member
- Joined
- Jul 26, 2007
- Messages
- 13
- Office Version
- 365
- Platform
- Windows
I'm trying to copy items from column A multiple times based on count in B into another column. I've tried using an i variable to loop and finding the next open cell but my jumble code that I've pieced together is worthless. I know that has to be super simple.
I've shown below the example items and counts in Column A and B and what the result would look like in column D. Can anyone point me in the right direction?
I've shown below the example items and counts in Column A and B and what the result would look like in column D. Can anyone point me in the right direction?
TEST COPY PASTE.xlsx | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | ITEM | COUNT | RESULT | |||
2 | ABC | 3 | ABC | |||
3 | DEF | 5 | ABC | |||
4 | GHI | 2 | ABC | |||
5 | JKL | 7 | DEF | |||
6 | DEF | |||||
7 | DEF | |||||
8 | DEF | |||||
9 | DEF | |||||
10 | GHI | |||||
11 | GHI | |||||
12 | JKL | |||||
13 | JKL | |||||
14 | JKL | |||||
15 | JKL | |||||
16 | JKL | |||||
17 | JKL | |||||
18 | JKL | |||||
Sheet1 |