Generate sample records from the big dataset based on 2 columns

[hash_89]

 I need to generate 3500 samples and need some representation of different combinations.

Here is how the data looks like

Name	Year	Subject
ABC	2021	Math
DEF	2022	English
GHI	2022	Math
GIH	2023	English
JIK	2024	Math
LHM	2024	English
KIK	2024	Science

I need to generate samples for combination of Year & Subject. It doesn't matter how many in each combination, but the overall sample should have records for all possible combinations in year & subject.

can anyone help?

[apathetichell]

Sample tool. select both columns in the group by. choose an amount. You will have that many items for each grouping.

[hash_89]

I did select the 2 columns, but it gives me more than 3500 for each year. 

[binuacs · Accepted solution]

@hash_89 Another approach

[apathetichell · Accepted solution]

@hash_89 N is the number of entries you want per combo. you are putting 3500 samples PER GROUPING...