Re: Data Cleanup

mshamsiev · ‎07-25-2017

Hi there,

I have a data dump from a survey which requires extreme clean up to be useable in my Power Bi dashboard. I was going to clean it up on excel to start with.

As you can see the questions are listed and each option is a subheading which the user fills in across the row. (each row is an indiviuals answers i.e. column A lists the emails).

Would anyone know how I can rearrange this as there are 27 questions each with sub headings or sub questions.

Please see the attached picture for reference.

Regards,

Mike

MattAllington · ‎07-25-2017

This is exactly what Power Query does (get data). You can see some examples with my online training, but explaining how to do this based on a picture is not practicable. If you posted a sample file, someone may help you.

Http://xbi.com.au/pqt

* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

mshamsiev · ‎07-26-2017

@MattAllington

Thanks for the reply Matt. Would you know how I can upload the sample file to the post?

Cheers,

Mike

MattAllington · ‎07-27-2017

Just load it somewhere (eg DropBox) and post a link.

* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.