Our favorite places and our favorite foods!
Fill out the following Excel file
Power Query M (Preprocess Data):
- Add Index column
- For Foods and Locations:
- Split by semicolon
- Unpivot
- Remove attribute column
- Rename value column
- Trim
URL: https://baylor0-my.sharepoint.com/personal/joshua_been_baylor_edu/Documents/Videos/Book.xlsx
Sample Dashboard (before clearing out content): Output Dashboard