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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.