Hi all,
I have a workbook that I want to split the cells in column L. Some data in column L have line breaks while some doesn't, what I want to achieve is to split any cell in column L with line breaks to a new row with the same row information except column L
Also column J will change depends on how many line breaks split, like if there's 3 line breaks then divide it by 3.
Please see attachment for better explanation.
Bookmarks