User Profile
chris-thompson
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
How to Split Multiple Columns Into Multiple Rows with Separate Groups of Columns
Hi all. I have a Microsoft Form that gathers all of the interventions that schools use with their students including specific information about each intervention (Type - Academic/Behavior; Subject - Math/Reading; Tier Level - Tier 1/2/3; and Grade Levels K;1st;2nd;3rd;4th;5th;6th;7th;8th;9th;10th;11th;12th). Each intervention (and it's associated characteristics) are in separate columns. How do I transform the data so that the data table looks like the third table below? (The image is also attached). I want to use PowerQuery and keep everything within Excel (not PowerBI or databases)
