Analyzing 365 License export

[Mike_Stroud]

I have a list of Microsoft 365 Licenses by user but the data is not in very friendly format (See attached file). I can text to column with the + as the eliminator but even then the licenses are not in the same columns so reporting on it is imposable. 

How do I get my data from this

User principal name	Licenses
User1@testcompany.co.nz	Power BI Pro+Microsoft 365 Business Premium+Azure Active Directory Premium P2+SharePoint (Plan 2)+Power BI (free)
User2@testcompany.co.nz	Power BI Pro+Microsoft 365 Business Premium+Azure Active Directory Premium P2+SharePoint (Plan 2)+Power BI (free)
User3@testcompany.co.nz	Power BI Pro+Microsoft 365 Business Premium+Azure Active Directory Premium P2+SharePoint (Plan 2)+Power BI (free)
User4@testcompany.co.nz	Power BI Pro+Microsoft Power Automate Free+Microsoft 365 Business Premium+Azure Active Directory Premium P2+SharePoint (Plan 2)+Power BI (free)
User5@testcompany.co.nz	Power BI Pro+Microsoft Power Automate Free+Microsoft 365 Business Premium+Azure Active Directory Premium P2+Power BI (free)

To something like this so I can then pivot it for reporting

User principal name	Licenses
User1@testcompany.co.nz	Power BI Pro
User1@testcompany.co.nz	Microsoft 365 Business Premium
User1@testcompany.co.nz	Azure Active Directory Premium P2
User1@testcompany.co.nz	SharePoint (Plan 2)
User1@testcompany.co.nz	Power BI (free)
User2@testcompany.co.nz	Power BI Pro
User2@testcompany.co.nz	Microsoft 365 Business Premium
User2@testcompany.co.nz	Azure Active Directory Premium P2
User2@testcompany.co.nz	SharePoint (Plan 2)
User2@testcompany.co.nz	Power BI (free)
User3@testcompany.co.nz	Power BI Pro
User3@testcompany.co.nz	Microsoft 365 Business Premium
User3@testcompany.co.nz	Azure Active Directory Premium P2
User3@testcompany.co.nz	SharePoint (Plan 2)
User3@testcompany.co.nz	Power BI (free)
User4@testcompany.co.nz	Power BI Pro
User4@testcompany.co.nz	Microsoft Power Automate Free
User4@testcompany.co.nz	Microsoft 365 Business Premium
User4@testcompany.co.nz	Azure Active Directory Premium P2
User4@testcompany.co.nz	SharePoint (Plan 2)
User4@testcompany.co.nz	Power BI (free)
User5@testcompany.co.nz	Power BI Pro
User5@testcompany.co.nz	Microsoft Power Automate Free
User5@testcompany.co.nz	Microsoft 365 Business Premium
User5@testcompany.co.nz	Azure Active Directory Premium P2
User5@testcompany.co.nz	Power BI (free)

[#2]

@Mike_Stroud 

Power Query could work - split text in second column to list and expand it. Please see attached.

[#3]

@Sergei Baklan - Thats great, so simple.

Thanks

Mike

[#4]

@Mike_Stroud , glad it helped