I would really appreciate some help in trying to figure this out.
I have a spreadsheet that presently contains 2 columns of data.
Column A contains one list of unique numbers (that can range from 1 to 10,000)
Column B contains a group value for those numbers (smaller range of 1 to 100)
I am looking for a way to repeat each value in Column A based on the number of times their corresponding Col B values appear.
The results could appear in Col C.
A | B
1 | 10
2 | 10
3 | 10
4 | 20
5 | 20
6 | 30
7 | 30
8 | 30
9 | 30
For example, in the table above:
The value 1 should appear 3 times in Col C (since its associated with the value 10, which appears 3 times)
The value 2 should appear 3 times in Col C (since its associated with the value 10, which appears 3 times)
The value 3 should appear 3 times in Col C as well (since its associated with the value 10, which appears 3 times)
Likewise, the value 4 should appear 2 times in Col C (since its associated with the value 20, which appears 2 times)
Similarly, the value 8 should appear 4 times in Col C (since its associated with the value 30, which appears 4 times)
Of course I've left out some of the other numbers in Col A, but I hope this makes sense.
As you can imagine, these value would get dumped into Col C and the list would be much longer than what appears in either cols A or B as the values in Col A should repeat based on count of times their associated Col B values appear.
I've also attached a spreadsheet which illustrates the above if it helps!
Thanks in advance all!
Bookmarks