Bring scattered data to correct columns

Please supply more details. A sample of what you are working with and what you want would be helpful as well.

Thanks for the reply I'm attaching a sample of what the spreadsheet looks like now and a sample of what I need it to look like.

Originally Posted by vadaniels

Thanks for the reply I'm attaching a sample of what the spreadsheet looks like now and a sample of what I need it to look like.

Hello, I know this post is quite old but if you often need to merge columns from distinct files or to merge similar lines, I suggest you have a look at podbox.com. It's an alpha release for the moment but moving fast to meet the users demand... It's free and will remain free. Please let me know if you want me to create your account to test it.

I'm having a similar challenge on formatting cells/columns/rows. i have a worksheet and the last row contains transaction descriptions.(extracted from a PDF bank statement). After converting the PDF to excel the last column had its rows scattered or separated how do i merge or trim them without having to do it one at a time cos its like 45pages
find attached an extract of the whole document.