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

chris-thompson's avatar
chris-thompson
Copper Contributor
May 04, 2023
Because PowerBI is not accessible to anyone outside of me (the organizations I serve will not have premium licenses), also, I know very very little about how to create a database, but I know a fair amount about Excel. In terms of your feedback, I have no idea what you mean. Could you clarify what you mean by "I know need data cleaning with regular expression"?
  • chris-thompson's avatar
    chris-thompson
    Copper Contributor
    May 05, 2023
    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.
    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      May 06, 2023

      chris-thompson 

      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's avatar
        chris-thompson
        Copper Contributor
        May 09, 2023
        I just tested it out and it works! Thank you so much!
    • peiyezhu's avatar
      peiyezhu
      Bronze Contributor
      May 05, 2023
      All roads lead to Roman.
      If possible share your file,I can try it with online tool.

Resources