Analyzing 365 License export

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 i...