Hi all,
My raw excel data format is as per below
| Eval No. | Evaluation 1 | Evaluation 2 | Evaluation 3 | Evaluation 4 |
| Evaluator Name: | W | X | Y | Z |
| Staff Name: | A | B | C | D |
| Score | 70 | 80 | 90 | 100 |
What i want is the first column values to become the column headers, and the remaining column data to become the row data
| Eval No. | Evaluator Name: | Staff Name: | Score |
| Evaluation 1 | W | A | 70 |
| Evaluation 2 | X | B | 80 |
| Evaluation 3 | Y | C | 90 |
| Evaluation 4 | Z | D | 100 |
I would like to know how i can do this without tampering with the raw excel data format. Thank you.
