Forum Discussion
Splitting Column with multiple lines of text
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.
Hi Anonymous ,
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
2 Replies
- Greg_Deckler
Community Champion
Perhaps try this: https://www.excelguru.ca/blog/2015/10/16/split-by-line-breaks/ 
v-deddai1-msftCommunity Support
Hi Anonymous ,
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
