Forum Discussion

chris-thompson's avatar
chris-thompson
Copper Contributor
May 03, 2023
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 -...
excel
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    May 04, 2023

    Hi chris-thompson 

     

    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

Lorenzo's avatar
Lorenzo
Silver Contributor
May 04, 2023

Hi chris-thompson 

 

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

Resources