get and transform

Hello, I'm trying to take a text file with data in the following format. The data begins like this: OGRID: [373075] XTO PERMIAN OPERATING LLC. Reference ID: fAPP2226958316 Reference Period: 202301 Days Reported: 18 Total Flared: 14,355 MCF Total Vented: 0 MCF OGRID: [373075] XTO PERMIAN...

I am going over tutorial from Microsoft website "Combine Data from multiple data sources". The issue is that on Step 6 "Group rows by ProductID and Year". In that step, I chose two columns and clicked on "Group By" and then got transparent windows and Excel stuck. This happened two times and...

Hi, all! I have a workbook with 12 spreadsheets, one for each year’s financial statements by month. They’re all formatted as financial statements. If I use Get/Transform to clean one sheet, can I use the PowerQuery “program” from the first sheet to clean the others? Or do I have to manually use...

HI Guys I have an experimental sheet with a shared link HERE. My quest is i have a file from eBay with my listings also I have a file from my supplier. I have merged two tables so I have my selling price on eBay & my supplier'ss price. I am trying to build a sheet that works out all the fees...

Hello! I have an issue with Power Query add-in. As you know, Power Query doesn't allow to work with files with extension .xls. The issue is that I have many files in my folder (over 50), the majority of which have extension .xls. I need to get and transform the data from folder with Power...

Can I use Get Data to link to a .iqy file?

Hi, I'm used to excel 2013 and Power query. Now I am using Get and transform in excel 2016. However, when I load a file or an analysis cube in 2016 it doesn't work... It says "please wait while we establish a connection..." Then when it times out: Unable to connect We encountered an error...

Hi I'm trying to create a budget helper for charity staff to make sure costs are calculated correctly when they put together budgets for funders. Some of the source data is confidential - ie Staff Salaries and needs updating regularly by different teams, so I've created source data in...