Forum Discussion
Confused on how to bring the needed data for the report view
So I'm not an expert in Excel, just know few basics and managing. There is a huge data file (Comes on a monthly basis) with thousands and thousands of rows and columns. There is one column with GL co...
Does the screenshot show the desired output? Then a possible solution could be Power Query. In the attached file i've made some minor changes to the layout of your data and created a dynamic (blue) table. You can add many rows and columns of data to the blue dynamic table. Then you can click in any cell of the green (result) table and right-click with the mouse and select refresh to update the green result table.