Hi all, I'm trying to take a merged cell that has multiple lines (in this case 8) and turn/paste it into 8 single cells in the same column. Is this even possible? I'm taking a PDF and converting it to an Excel file, but its making each of the columns into one big, merged cell. I've seen the 'Text to Columns' is a way that many split merged cells, but I dont think it would work in my case. I've attached an image to show what I've got and what I want to turn it to. Thanks.
