Transform data

[Gerald23]

Hi Everyone,

Hope someone can help me.

I have a source .txt file that looks like this:

And I want to transform this data within the power bi desktop to look like the table below so I can build my dashboard based off this file. How can I accomplish this?

 

[amitchandak · Accepted solution]

@Gerald23 , Import as : as the delimiter. 

then try to pivot the two columns , use max for values.

If needed remove space.

[ribisht17]

Hey @amitchandak 

'

With Minimum it gives a single row

Expression.Error: There were too many elements in the enumeration to complete the operation.
Details:
[List]

With do not aggregate it shows an error,

I know this is a solution but what could be the problem here ?

Regards,

Ritesh