Forum Discussion

TheProfessor07's avatar
TheProfessor07
Copper Contributor
Dec 25, 2024

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 codes and one row with entity codes, so basically the cell provides the amount. Many of the cells have zero in it (Meaning no transaction)

Client already has a report which pulls the data based GL codes, basically the total of account. The client wants a new report to pull the data based on GL codes(Column) and entity codes (Row), so that he gets detailed, clean view and can be updated monthly.

Here is the mock version of the data. I want to bring over the data in a new sheet with the GL Codes and entity codes.

I'm not sure what exactly to do since I'm not that well versed with excel. Please help your fellow mate 🥹

Apologies if my English is bad. TY!



  • 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.

Resources