Split text by delimiter for column

[WhatisPowerApps]

Hi,

How do I split text multiple texts by delimiter for the column? How do I go about getting the Result table below? 

MyTable

Manager

Name1

Name3, Name4, Name5

Name2

Name7, Name6

Result

Manager

Name1

Name2

Name3

Name4

Name5

Name6

Name7

[RandyHayes]

@WhatisPowerApps 

The following formula will provide you with your results:

RenameColumns(
    Sort(
        Distinct(
            Ungroup(
                ForAll(MyTable, {Manager: Split(Manager, ", ")}),
                "Manager"
            ),
            Result
        ),
        Result
    ),
    "Result", "Manager"
)

I hope this is helpful for you.

[WhatisPowerApps]

@RandyHayes 
Thanks for helping me. What if I have another column?

MyTable

Manager	Country
Name1	USA
Name3, Name4, Name5	UK
Name2	UK
Name7, Name6	USA

Result

Manager	Country
Name1	USA
Name2	UK
Name3	UK
Name4	UK
Name5	UK
Name6	USA
Name7	USA

[RandyHayes · Accepted solution]

@WhatisPowerApps 

Always good to present all information 😉

The formula would change to:

Sort(
    ForAll(
        GroupBy(
            Ungroup(
                ForAll(MyTable, {Manager: Split(Manager, ", "), Country: Country}),
                "Manager"
            ),
            "Result", "_data"
        ),
        {Manager: Result, Country:First(_data).Country}
    ),
    Manager
)

[WhatisPowerApps]

Thank you so much for helping me out with this formula! 

Sorry for not presenting all information 🙁

[RandyHayes]

@WhatisPowerApps 

No worries.  It's an easy flip of the formula!

Gald it was helpful.