Using Power Bi To Fix Corresponding Null Rows

[PassRusher]

So I hope I can explain this well enough...

I am trying to report Ticketing Information (IT Support) out of a program called NinjaOne. It is basically a CSV dump to Excel and I save as an Excel document. I just want Status, Subject, Comments and Assignee and I clean it up manually to zero in on what I want. 

The problem with this dump is if I sort it, all Comments go down at the bottom because they are on a row that has no STATUS…but they are associated with the status/ticket just above it...those "blank rows" in the picture below are the rows where the comments are (not pictured, to mask sensitive data.) 

So is there a way to use Power Bi to group these comments with the status / ticket above it? I tried to import into Power Bi but not sure what to do from there...would I need a template of sorts for each week I do this?

[foodd]

Hello @PassRusher and thank you for starting a conversation in the Power BI Desktop Community Forum.

• This is a classic Power Query activity which you could from the description handle in Excel or Power BI.  If you would share alink to a copy of the CSV as Excel, as well as a list of columns by name, and what the resulting table should look like we can take a peek at it.   This should go rather quickly, and result in a query that can be reused going forward.

=-=-=-=-=-

If you find this insightful, please provide a Kudo and accept this as a solution.

[PassRusher]

I am going to send a truncated version...this will contain possible private information so the link will expire over time...

Primaraly, I need the null rows associated with the case above it to be included when trying to report on this...

When preparing report, I will just need Case/Date Modified/Subject/Status/Assignee and Comments...with the emphasis on keeping the comments with the case. 

sample_report_01.xlsx

[PassRusher]

If I need to extend the experation date on the file share, let me know. Also, if we get this working, I will be so glad to do a "Buy Me A Coffee" donation or the like. 

[foodd]

Hello and good morning!   You can delete the sharing link, I am using a local copy for the work.  Let me see what I can do to send up a working draft this afternoon. 

[PassRusher]

Thank you SO much!

[Anonymous]

Hi @PassRusher 

Have you solved your problem? If solved, you can mark @foodd 's reply as a solution. This will help more users who are facing the same or similar difficulties. Thank you!

Best Regards,
Yulia Xu

[foodd]

Sent PM