I have some data that I need to flip and copy & paste vertically based on the value at the intersection of a row & column. Below is the data as it is currently & how I need it to look. The result is based on where the policy is marked as 'Required' for that job & policy. I have tried various, inelegant formula options, and some VBA but cannot get either to work. I need it to loop through roughly 400 rows and 125 columns. I've looked thru the forums to see if something similar was asked/posted but came up empty. So, any help would be greatly appreciated!
Current:
A1 B1 C1 D1
<tbody>
</tbody>
Result:
<tbody>
</tbody>
Current:
A1 B1 C1 D1
Job | Policy 1 | Policy 2 | Policy 3 |
Electrician-Journeyman | Required | Required | Required |
Facilities Maintenance | Required | Required | Required |
Maintenance Manager | Required | Required | Required |
QA Manager | N/A | Required | N/A |
Warehouse Manager | N/A | N/A | Required |
<tbody>
</tbody>
Result:
Policy 1 | Electrician-Journeyman |
Policy 1 | Facilities Maintenance |
Policy 1 | Maintenance Manager |
Policy 2 | Electrician-Journeyman |
Policy 2 | Facilities Maintenance |
Policy 2 | Maintenance Manager |
Policy 2 | QA Manager |
Policy 3 | Electrician-Journeyman |
Policy 3 | Facilities Maintenance |
Policy 3 | Maintenance Manager |
Policy 3 | Warehouse Manager |
<tbody>
</tbody>