List items based on the count given
Hi all,
I have a problem that requires some help here.
I have a table that list items and the frequency for each item, as shown below
Item frequency
A 1
B 3
C 4
D 1
E 0
Base on the above, the system should populate a list base on the above
Expected result is:
Item Count
A 1
B 1
B 2
B 3
C 1
C 2
C 3
C 4
D 1
Item E is not displayed because the frequency count is zero.
Anyone could assist on this?
Many thanks in advance
Last edited by CS Chia : March 12th 14 at 08:06 AM
|