Forum Discussion
.xml file splitting lines into different rows
I am working with an .xml file from a subtitling software and when I open it in excel, it creates a schema for it and then in the column with the subtitles, some of the subtitles are split into diffe...
HuskerKnight If I have understood the CONCAT tool correctly, I think I would still need to manually check all the rows that need joining or not, as some do and some don't, so I am trying to find a fix which doesn't involve manually checking the whole file– unless I am missing something with how I can use the CONCAT tool, please let me know if so!
Do you have an example? I'm not sure I follow..laura_y