Forum Discussion
table auto format
Hello everyone - I am trying to find out the best method to automate a report format. I would like to: 1) Extract a spreadsheet from an application and format the table automatically (ie: remove ...
jtpiazza If you can do it in Power BI, use Power Query in Excel.
In Power BI I can drag and drop the fields into a table in the order I want. I don't see how I can do that in Excel without creating a pivot table. Am I missing something?
In Excel you don't have visuals like in Power BI. What you may do that's reference the main query, adjust columns as needed and load result into the grid.
