Rearranging data to another sheet in excell

Closed
Michael - May 4, 2010 at 05:49 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 4, 2010 at 06:01 PM
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.
Ex.)

Male True
value FSAD89
Mac perrit
integer Yes
Married False
school No
College no
City unknown


Male True
value qretFSAD89
Age 26
Mac perrit
integer Yes
Married True
school Yes



Male False
value FSsqlAD89
Mac perrit
integer Yes
Married False
school No
.
.
.


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?

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 4, 2010 at 06:01 PM
Yes possible with a macro.
1. Find the last used row
2. loop thru all rows
3. in each row
3a. look for item that you wanted
3b. copy to the new sheet
3c. if row is blank then presume that new record
1