Forum Discussion

Mai_Nashaat's avatar
Mai_Nashaat
Icon for Helper II rankHelper II
5 years ago
Solved

Get Data from different tables in specific formate

Hi everybody, I'm struggling with an issue hope anybody will help me solve it. please I've table for target of the sales with company name  A table with company names, branches and sales I've d...
  • lbendlin's avatar
    5 years ago

    in Power Query there is a "Fill Down"  transformation that you can apply to the Comp Name column in your second table ("Table 3").  That will then allow you to properly assign branches to companies.