how to populate the field values according previous field value

[raji6763]

hi ,

i want  to populate the field values according previous field value

1	key1
1
Raju
1
2	key2
2
cbe
2
3	key3
3
3
3

expected output:

thanks

[Mastan]

.  These are all of the audits that have selected “No” for Data Usage (Yes/No).  All of the data field names are highlighted in blue.  For the Quality Control sheet, I want to see all audits where there is a data field highlighted in yellow.  Meaning they said No they did not use data on the audit but answered the data questions as if they did use data on their audit.