b$.$ Create a reference query for the Hobbies multi$-$select survey question and name it Hobbies. Select the following columns for the Hobbies reference query: NetID, Program, Hobbies. You should now have $4$

$7|Page|$

queries in your Power Query "queries" pane related to the Student Data:

c$.$ In the Industry reference query, split the Industry column by a delimiter in order to put each industry value in a separate column. Hint $-$ Pay close attention to the delimiter you choose here. Power Query will guess which delimiter it wants you to use, but it isn't always correct. Our delimiter is a comma.