Forum Discussion
Solved
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 -...
Your 1st challenge is exactly the same as Automatic Data entry manipulation where @CWsChim was smart enough not to mark any possible solution so you almost had no chance to find it when you Searched :-((
For your 2nd expected view, the approach is the same. Once you have your first view, Split column [Grade Levels] by Delimiter to Rows then do the same for [Tier Levels]:
Next time(s) please share a sample workbook, recreating data takes unecessary time - Thanks
I appreciate the suggestions but none of them really address how I get from the data looking the way it does in the first table of my document, to the bottom table. That is what I need to be done.
All roads lead to Roman.
If possible share your file,I can try it with online tool.
If possible share your file,I can try it with online tool.