I have received a PDF file. I have a software that converted the same into a MS Exel file. Only issue is that the main content row puts everything into a single cell. While wherever horizontally appears a number in the QTY column, this should be in a separate row. I have thoroughly googled a solution and found many tips but ended up empty handed.
I have attached the file which requires rows to be segregated. In the same Excel file there are two tabs. The converted sheet and the Sheet (which I have done manually) of how I'd like the rows to be segregated. Please note: column are fine.
Here's the file: Test-File.xlsx
Any help to solve this issue is much appreciated. Thanks.