Forum Discussion
Solved
Table Possibilities
Hey guys,
I've got some data listed in the first table below that has multiple locations. I'm trying to find a way to list out every item's location with its relevant information, essentially turning it into the second table. I'm trying different combinations of XLOOKUP but I'm stumped. Should I be using a pivot table instead?
This is a job for Power Query in my opinion. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
This is a job for Power Query in my opinion. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
Thank you! I've used power query before when extracting data from a .txt file, but I did not know it was capable of this.
