I have one workbook and two sheets

1 sheet has

data for automated test scenarios that may be run up to 3 time if they
don't pass on the first or
second try

Sheet1:
TestSet Test Result reason if failed

1 pass
2 pass
3 pass
4 fail x
4 fail y
4 fail z

I want to create a summary report that looks like Sheet2 for the
Sheet1 logs above
test run1 result test run2 result test run 3result

Sheet2
Testset result1 result2 result3
1 pass
2 pass
3 pass
4 fail fail fail

So if a testset is executed more than once such as testset #4 I want
to be able
to transpose the resuts from rows to columns.


Any suggestions would be appreciated. In the meantime I am going to
try the transpose function.