when processing text based files such s PDF, Word but also Excel, CSV, you name it, data in cells frequently contain multiple lines. Splitting cells by a line break to be able to extract the data is not desired as it would scramble the data.
I do have developed techniques to cope with these situations but it’s quite a chore. Here is one example where I recently faced the issue when trying to help someone in the forum.