So i have this excel file full of data relating to a survey taken from roughly 1700 households. Each household is number (1,2,3,4...) and has corresponding columns relating to it such as no. of people in the household, whether children go to school etc. My problem is, is that i need to take a random sample of 1400 households and still carry over the corresponding data from the neighbouring columns, but whenever i use the sample data toolpack, it just takes 1400 random number across all columns. If you could please help me, it would be greatly appreciated.
The data file is attached below.
Solved by D. L. in 16 mins