Splitting Column with multiple lines of text

[SmedinghoffUNLV]

I have a column of data I'm trying to split out that looks like the folowing:

Academic Pay

FN40 Academic Support

J000613 - Librarian - III

Monthly

P0064472 Librarian - III - NAME HERE

Regular

UNLV1-Medical District

All of my attempts to break this out into multiple columns has failed. Looking for suggestions. I'm relatively new to Power BI, so apologies if I've overlooked something simple.

[v-deddai1-msft · Accepted solution]

Hi @SmedinghoffUNLV ,

Would you please try to split the column by line break(#(lf))?

Then move the blank columns:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[Greg_Deckler]

Perhaps try this: https://www.excelguru.ca/blog/2015/10/16/split-by-line-breaks/