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...
Could you use 'CONCAT' to get them all in one cell? laura_y
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
