Forum Discussion

SVADDE21's avatar
SVADDE21
Frequent Visitor
1 year ago
Solved

Help needed in transforming data in Power Query

I have this data in Excel. when comes to Power BI, it comes as below screenshot. We can modify data in Excel as separate rows, but it has huge data and so much manual work. Is there anyway in power q...
Need Help
  • pankajnamekar25's avatar
    pankajnamekar25
    1 year ago

    Hello SVADDE21 

     

     Select the IP Address column → go to the top menu and click:

    Transform → Fill → Down.

    Do the same for the Server column:

    Select Server → Transform → Fill → Down.

    Thanks,
     Pankaj Namekar | LinkedIn

    If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

burakkaragoz's avatar
burakkaragoz
Icon for Super User rankSuper User
1 year ago

Hi SVADDE21 ,

 

You can totally do this in Power Query using the Fill Down feature. Here’s how:

  1. In Power Query, select the column that contains your product names.
  2. Go to the Transform tab and click Fill > Down.
    • This will copy the product name from the row above into any blank rows below it—until a new product name appears.
  3. Now, each row will have the correct product name filled in, and you can use that for grouping, filtering, or analysis.

If you want to take it further and create a new column that flags the “header” rows (the ones that originally had the product name), you can do something like:

= Table.AddColumn(PreviousStep, "IsHeader", each if [Product] = [OriginalColumn] then "Yes" else "No")

Let me know if you need help with the exact M code—happy to help!

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
translation and formatting supported by AI