tables linking

  1. 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...
    • phbryan
    • Thread
    • lookup 2 values power query tables linking
    • Replies: 7
    • Forum: Power Tools
  2. M

    Suggestions for Complex Report Layout

    I was asked to keep track of a project and need to report on its progress every month. The raw data will be names, office locations, current model assignments, new model assignments, and the date the new model was reassigned. Initially, I was going to create monthly tables based on this data...
  3. T

    Extrapolating information from one table to another

    Hello Everyone, I am new to this so apologies for any bad form in Forum etiquette. I currently have a master table on one sheet and I am looking to create a couple of other tables on separate sheets. I am looking to link the tables so that the new one can extrapolate some of the existing data...
    • Tloso
    • Thread
    • tables tables and relationships tables linking
    • Replies: 1
    • Forum: Excel Questions

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