I am working on employee data and the data I  have received comes with two cells (Proj Name and Count of Hours) which have multiple names/ hours in the same cell separated by line breaks.I have looked through the solution presented in this link Google sheets split multi-line cell into new rows (+ duplicate surrounding row entries) but it only appears to work when there is one column with multi line unlike mine which has more than one which needs to be split.Help will be appreciated as I am a newbie when it comes to scripting. Thanks!
Splitting Multiple Multi Line Cells into new rows
google spreadsheets