Forum Discussion
How to Split Multiple Columns Into Multiple Rows with Separate Groups of Columns
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
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
Are you saying the proposal I shared doesn't do it? Did I miss something?
chris-thompson Glad this helped
& Thanks HansVogelaar for marking the solution on your behalf - This helps those who Search so don't forget next time(s) please