Hi Team,
I have an Excel file that contains the following columns:
- Id (Column A)
- BMW (Column B)
- Porsche (Column C)
In Columns B and C, the business has populated each cell with either a value of (A) or (R). (There are also Records which have no value populated)
Example Data
| ID | BMW | Porsche |
| 11111 | A | |
| 22222 | | A |
| 33333 | A | A |
| 44444 | R | |
| 55555 | | R |
| 66666 | R | R |
| 77777 | | |
I would like to transform this data from a vertical to a horizontal format.
Desired output
| Id | Outcome |
| 11111 | BMW - A |
| 22222 | Porsche - A |
| 33333 | BMW - A |
| 33333 | Porsche - A |
| 44444 | BMW - R |
| 55555 | Porsche - R |
| 66666 | BMW - R |
| 66666 | Porsche - R |
Looking forward to your assistance
Regards
