Remove first ten rows for specific Company name

adombayeva

Hi,

Could you please advise how to remove first 10 rows within 15 rows for each country name? Basically I need to remove 1-10 and leave 11-15 for UK, same way remove 16-25 for USA and leave 26-30; etc. There are more than 2000 records and more than 10 countries.

The data set  as follows:

Record #      Country 

1                   UK

..                   ...

5                   UK

...                  ...

10                UK

11                UK

12                UK

...                 ...

15                UK

16                USA

17                ...

...

25                USA

26                USA

...

30                USA

31                RUS

32                RUS

...

39                RUS

40                RUS

41                RUS

...

45                RUS

Thanks

PeterA1

Hey @adombayeva 

I think this can be accomplished by using a sample tool   And configuring it to "Skip First 'N' Rows" In this case "10 or 15, and then select "Group By: Country" In the box below.

This will skip the first N by country.