Forum Discussion
Index Match with multiple criteria
Hello, I need to have a reference from a table with 2 headers to a different table. The number of the week and the type of planned work are horizontal in the original file. In the new table,...
Celia9 I would recommend that you look into Power Query for these kinds of transformations. The attached file contains a query that you can use over and over again.
I named the data in the "Original file" tab MyData and loaded it into PQ. Than I did some relatively simple transformations, just by pressing the correct buttons in the user interface. The green table in Planned is what PQ makes of it. No need for complicated formulas.