Help needed in transforming data in Power Query

[SVADDE21]

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 query to separate the rows and get IP address and server filled in all relavent rows?

So I want something like this in Power BI

Thanks for the help

[Anonymous]

Hi @SVADDE21 ,
I just wanted to check if your issue has been resolved. If our response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful. If you have any further questions, feel free to reach out.
Thank you.

Regards,
Pallavi.

[burakkaragoz]

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

[pankajnamekar25 · Accepted solution]

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.