The excell in which i am having consists of lot of data. I need to get few particular calues out of it to another sheet.
The above are the sample data. I need to get the above in the following pattern
Male Age Married School College
True FALSE NO NO
True 26 True YES
FALSE FALSE NO
Please note that few values are missing in few sets and unwanted data is available in each set of sample data. The row length is n. after every set 2 blank lines left. Is it possible to arrange the Sheet in the above mentioned manner?