Hello All,
I am looking to get a transposed excel export (as shown in output below) from the below two horizontal data to a single sheet. I want to retain the color coding even while exporting in to excel as shown in the output.
Also the output should always one below the other.
Color coding -
Pass value - Green background
Fail Value - Red Background
Manual Review - Green Background
Input
| Row | Results | Check 1 | Check 2 | Check 3 | Check 4 | Check 5 | Check 6 | Check 7 | Check 8 | Check 9 | Check 10 | Check 11 |
| 123 | Field 1 | Mango | adbc | Apple | Strawberry | Guava | Grapes | Pineapple | Mustard | Rice | Wheat | Pizza |
| 123 | Field 2 | - | adbc | 12345 | Strawberry | 48445 | Grapes | Pineapple | 1544 | Rice | knasdfknafds | Pizza |
| 123 | Outcome | Fail | Pass | Manual Review | Pass | Fail | Pass | Pass | Manual Review | Pass | Fail | Pass |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| Row | Results | Main Check1 | Main Check2 | Main Check3 | Main Check4 | Main Check5 | Main Check6 | Main Check7 | Main Check8 | Main Check9 | | |
| 123 | Data1 | Car | Cycle | Truck | EV | Lorry | Motorcycle | HK | POAddress | 1234S56 | | |
| 123 | Data2 | Bike | Cycle | | EV | | Motorcycle | CITY | ADDRESS | 456 | | |
| 123 | Outcome | Manual Review | Pass | Pass | Pass | Fail | Pass | Fail | Manual Review | Manual Review | | |
Output -
| Row | Results | Field 1 | Field 2 | Outcome |
| 123 | Check 1 | Mango | - | Fail |
| 123 | Check 2 | adbc | adbc | Pass |
| 123 | Check 3 | Apple | 12345 | Manual Review |
| 123 | Check 4 | Strawberry | Strawberry | Pass |
| 123 | Check 5 | Guava | 48445 | Fail |
| 123 | Check 6 | Grapes | Grapes | Pass |
| 123 | Check 7 | Pineapple | Pineapple | Pass |
| 123 | Check 8 | Mustard | 1544 | Manual Review |
| 123 | Check 9 | Rice | Rice | Pass |
| 123 | Check 10 | Wheat | knasdfknafds | Fail |
| 123 | Check 11 | Pizza | Pizza | Pass |
| | | | | |
| Row | Results | Data1 | Data2 | Outcome |
| 123 | Main Check1 | Car | Bike | Manual Review |
| 123 | Main Check2 | Cycle | Cycle | Pass |
| 123 | Main Check3 | Truck | | Pass |
| 123 | Main Check4 | EV | EV | Pass |
| 123 | Main Check5 | Lorry | | Fail |
| 123 | Main Check6 | Motorcycle | Motorcycle | Pass |
| 123 | Main Check7 | HK | CITY | Fail |
| 123 | Main Check8 | POAddress | ADDRESS | Manual Review |
| 123 | Main Check9 | 1234S56 | 456 | Manual Review |
