I’ve been combining sheets out of a folder using power query. Problem I have is some sheets have 4 columns and some 3.

I’ve been combining sheets out of a folder using power query. Problem I have is some sheets have 4 columns and some 3.

My company requires an excel sheet to calculate multiple factors for employees. I currently have this set up to calculate for one employee at a time by have a named cell, EMPID, which is thrown into Power Query to automatically calculate this information. However, this method only allows one employee’s information to be ran at a time and there are occasions where 10+ employees will need to be ran.

I have a table in power query “MASTER_Global Game Table” which has multiple columns in it. I have added an additional column which I would like to provide an average of another column for all rows that have matching values in another column. So….

I am importing data from an excel table into Excel power query. The excel table has decimal data but formatted as Text.
When I import this table into Excel Power Query, it reads the decimal data and adds more digits to its end. For instance, the number 1.1 in excel is converted to 1.1000000000000001. Note that not all the numbers are imported in that form. For instance, the number 2.1 is imported as it is.

I’m facing a very strange behavior.

I 2 columns in Excel with times, I need to round one column down to the nearest 5 minutes and the other one up to the nearest 5 minutes.

So I’m receiving an Excel file with RefID information provided for TypeA users. This table is named and is on Sheet1

I wanted to develop dynamic file path for txt file but it keeps giving me error on the “filecontents” step below:

My end goal is to pull 2 data points from internal company url and display it in excel.