Reposting since I can't find the previous question.

I have a spread sheet that contains 2 columns and multiple rows:

WORKSHEET1
ProgamName Level
Prog1 29
Prog2 27
Prog3 25
Name1 95
Name2 97
Name3 98


I want to look for all "Prog1" values in another worksheet2 (same file) and
check the cell to the right if the value is equal to "29" from value shown
above. If the 2 values match then I want to copy the entire row from
workshee2 and paste them into worksheet3 using the transpose option.
Each row would be transposed to the next empty column in worksheet3

I want to repeat this process for each row in workshee1

Is this possible ?

Thanks,

El Bee