power query

  1. B

    More Efficient Way to Replace Values

    Hi, Is there a more efficient way to replace "Cash" with "Other Income"? I created a Group By Journal ID to identify which Journal IDs have an "Other Income" row and replaced GL Name with GroupBy.JournalID if GroupBy.JournalID is not null. Journal IDMemoGL...
  2. R

    Power Query - Fill.Up Function

    Hey Everyone, Is there a way to use the Fill.Up function to Text.Combine a particular column? Scenario: I have duplicates stacked on top of each other, I want to fill the blank spaces with the data below unless updates were made on the new line. Where I'm stuck is the "Notes:" column. I don't...
  3. R

    Merging Data Values From Separate Rows - Based On Conditions

    Hey Everyone! I'm fairly new to Power Query and I have managed alright so far but I need help making my process more efficient without sacrificing the specific data values I need represented. **Sorry in advance for the crazy amount of columns, I promise they all serve a purpose.** Data is auto...
  4. S

    Producing project report in power bi based on timesheet data

    I'm working with the excel timesheet format my boss uses (and does not want to change), so I'm having to figure out how to clean up that data and make it usable. I'm working on generating project reports based on those timesheets. I want to create a visual report that tracks hours worked per...
  5. D

    Power Query use list of URLs as source

    Hey, I have a gazillion of files that have data that I'd like to load in a central file. In the central file, I have an excel table with the file path/url of those files. The paths/urls can change, hence the table. Can I utilize that table to load in the source files without having to set up...
  6. R

    Fuzzy Match different product titles to find Duplicates but with-in same brand name

    Hi all, I have a list of products by different brands and I am trying to find all such duplicates and variants. For simplicty, let's say my sheet has 3 columns: brand, product_name, manufacturer_name. There could be duplicate products created due to differences in the title. Example...
  7. DRSteele

    'Unable to connect' error

    Can someone please help me with a Power Query problem that has cropped up? In a query, I am now unable to connect after years of successful use. The error is titled "Unable to connect" and then says "Access to the resource is forbidden". This query is in a worksheet, and it churns away and...
  8. X

    Power Query Reference vs Duplicate for Performance

    If I have query (1) with multiple steps and I need to have query (2) based on query (1). For performance and/or good practice is it better to: A) duplicate it and then modify and or remove the steps carried over to get what I need or B) is it better to reference it and then create steps to...
  9. tazeo

    Hierarchical Table to a PivotTable (or something similar)

    Hi everyone, I'm struggling with transforming a complex Hierarchical Table into a format suitable for creating a PivotTable. The existing data structure is proving challenging to work with. Current Data Structure (example): Level 04level 05level 06level 07level 08level...
  10. S

    Expanding Abbreviations Within an Address Column

    Hello experts, I've got a canned report that I need to modify in Power Query so that it can be used to create an Excel mail merge list. The powers that be don't want any abbreviations in these addresses. For example, Joe Smith's employee record comes out in the pre-canned export as 103...
  11. M

    Scraping table from site with multiple pages but same url

    I cannot figure it out. I am trying to scrape a table from the website CapWages - NHL Salary Cap Data which will scrape the first 50 rows but because the website makes you click next page, it will not display the next ones. Normally, websites add to the url to advance the page...but this site...
  12. C

    How to automatically paste the data from one sheet to another using VBA

    Hello All. I created a macro wherein the data captured from SAP and imported via power query will automatically pasted on another sheet of the same worksheet, what happened is that even though the query is updated once I ran the macro it captured the previous data generated from power query...
  13. M

    Help rearranging dataset (pivot, lookup, or something else?)

    Sorry for the uninformative title; I'm not sure what to call the thing I'm trying to accomplish. I'm importing data from a PDF and hope to rearrange them into a more useful structure. I have a list of widgets, grouped by the subwidgets they're made of. So the initial import looks something like...
  14. J

    Update Power Query through VBA

    Upfront Admission: My VBA skills are limited to one lines of code and plagiarism. So I will be zero percent offended if spoken to like a Excel baby. That said. I am working on a Power Query file that is reading a folder location of PDF files. From those files, I scrape out permanent information...
  15. P

    Power Query to Merge and Fill in gaps in data

    Hello, I have monthly sales data by item for 12 months. Some items do not have any sales data in every month. My raw data source omits these months and skips over them. However, I need to show these months/item as ZERO for that month. Some conditions that are always true: 1. For any month in...
  16. I

    Power Query Data types and excel time format issue

    So, I have a column for time duration in my data from different excel files and tables which gets consolidated in power query... But the data in the time duration column from these different files/tables is not the same, it's in these below 3 example formats: 00:24:02 00h 24m 02s 24m 02s 01h...
  17. Y

    Is there a way to run power query in Excel 2006?

    I have read that power query is not supported in Excel 2007 and earlier versions. I would like to know if there is any other way to run power query in Excel 2006? I have an assignment to run Power Query and my Excel is 2006. Any comment is highly appreciated.
  18. D

    Power Query: Pivot Column With Multiple Values Columns OR Hierarchical Header

    Good day, In Power Query, I need to go from this: Serial Number Date/Time Data Pont 1 Data Point 2 0001 08/14/2024 10:00 DP1A DP2A 0001 08/14/2024 10:10 DP1B DP2B 0001 08/14/2024 10:20 DP1C DP2C 0001 08/14/2024 10:30 DP1D DP2D 0002 08/14/2024 10:00 DP1A DP2A &c. to this...
  19. S

    Processing 2,000 CSV files

    Hi, I have an excel file that is 80mb in size. I have daily files for several years that I upload each day. I would like to see if I could save time by storing prior years already. They are csv file format 365 files x 4 years and take 30 minutes to upload each day. Each morning I need to open...
  20. CubaRJ

    How to replace text in a column based on values of next and previous row?

    Hi, There! I am looking for a way to use Power Query to replace text in two diferent columns based on a column. This is a report coming from HR listing daily information about punch cards. It contains the names of personnel and their time stamps and overtime code. I have this column reason...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top