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.
![nhSZU7U.png](/board/proxy.php?image=https%3A%2F%2Fi.imgur.com%2FnhSZU7U.png&hash=504d2cbbdc397b7f1645397043729471)