fill up

  1. 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...
  2. 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...
    • Rana Gray
    • Thread
    • conditions fill up group by merge cell based value power query
    • Replies: 2
    • Forum: Power Tools
  3. svendiamond

    Macros work separately but not together

    The point of this workbook I'm creating is to make an ugly system-generated report look nice. The user pastes the report onto the first page, then clicks a macro button that does everything. "Everything" includes deleting some columns to make it line up correctly, then copying and pasting the...
  4. svendiamond

    Fill Up Automatically?

    The Job Function/Area/Department columns in this report all come out AFTER the list of names for each. I.e. Raymond G worked in "SUPPORT" -- Steve P worked in CRTVLOAD -- Matt S and Steve P worked in RCVCRTV. I want to (automatically) FILL UP the Department/Area/Job Function columns so that...

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