Sorting columns out based on data

Hello,

I am importing data from Asana into PowerBI with the hopes of tracking the amount of time spent on tasks and tracking which users are spending X amount of their time on which tasks. Since this data is being imported directly from Asana, I unfortunately cannot reformat the data at the source. Custom fields can be created in Asana to create the data we want, but all Custom Fields end up being aggregated into a single column in PowerBI, which is not helpful. 
One of the things I am trying to do is create a pie chart based on the "Effort" of each task that is applied to an "Operation". In the column named "Custom Fields.name", I would like those 2 fields to be their own columns (named "Effort - Sprint Planning" and "Operations - Sprint Planning", respectively). I would like the data from the column "Custom Fields.value" to be the values that populate these 2 columns, with the decimal values under the "Effort - Sprint Planning" column and names like "Administrative" under the "Operations - Sprint Planning" column. I tried pivoting the columns, but it doesn't keep the Values paired with the appropriate Operation (values and Operations are in separate columns, but the row of data next to say, Values shows as "null", with what should be the paired Operations value in a separate line (and paired with its own "null" value).

How can I re-sort this information into the different columns while keeping the remainder of the data lined up correctly?