View Single Post
  #1   Report Post  
CS Chia CS Chia is offline
Junior Member
 
Posts: 15
Default 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