vba macro to perform custom reporting -transpose from rows to columns

V

vba_newbie

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Formula to count text string in column cells of filtered rows 3
INDEX return multiple columns 1
Cell values to an array, then array transpose to another workbook 8
Macro Pause to Select range then Subtotal 0
How to Use VBA to Group and Transpose Data... 0
assistance needed: transpose data from rows to columns 1
Determining a Status Based on multiple rows in a query 6

Top