function dataset CreateData(dataset ds1, dataset ds2)
{
	dataset ds3;
	ds3.SetSize(total(ds2));
	int idx = 1;
	for (int i = 1; i <= ds2.GetSize(); i++)
	{
		for(int j=1; j <= ds2[i]; j++)
		{ 
			ds3[idx]=ds1[i]; 
			idx++;
		}
	}
	
	return ds3;
}
col(C) = CreateData(col(A),col(B));

quote:

---

Originally posted by YimingChen

Hi,

Please create a worksheet with col(A)~ size, col(B)~ frequency, col(C) empty. Then run the following script in script window. (Window: Script Window)

Thanks,
James

function dataset CreateData(dataset ds1, dataset ds2)
{
	dataset ds3;
	ds3.SetSize(total(ds2));
	int idx = 1;
	for (int i = 1; i <= ds2.GetSize(); i++)
	{
		for(int j=1; j <= ds2[i]; j++)
		{ 
			ds3[idx]=ds1[i]; 
			idx++;
		}
	}
	
	return ds3;
}
col(C) = CreateData(col(A),col(B));

---