Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
Thanks for the reply Matt. Would you know how I can upload the sample file to the post?
Cheers,
Mike
Just load it somewhere (eg DropBox) and post a link.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |