Rearranging data to another sheet in excell [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
763
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!