This is an Excel question and not a Google Sheets question. I have a table of static data on the worksheet EC2_Pricing I am trying to recreate it using an API query through Power Query and place it into EC2_Pricing2. I need to transform this data within Power Query before it arrives in the table.
Solved by G. B. in 29 mins