Hello everybody,
I would like to convert this kind of excel table into the second one
The idea is to put a formula in the table2 to find in A2: the first choice for alex is to take car. For Mat the 1st choice is to take plane etc...
If the idea is not clear, I have share the excel file.
Car Plane Boat Moto walk
Alex 1 2 3 4 5
Mat 3 2 1 5 4
Jo 4 1 2 3 5
1 2 3 4 5
Alex Car Plane Boat Moto walk
Mat Boat Plane Car walk Moto
Jo Plane Boat Moto Car walk
Many thanks in advance.
Bookmarks