How to Split Multiple Columns Into Multiple Rows with Separate Groups of Columns

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