How Do I Multi Copy And Paste Different Columns in Excel?

I have a question, I got a product feed from my supplier, he they only do the product data feed in text only. They don't do in CSV like most companies. I was able to open the text feed in Open Office calc writer and it shows them mapped into different columns. I was going to copy and paste each column into my excel to create my own CSV easy. But there as a problem, some of the items in the columns were not mapped into the right column, some would be mapped in the column before the proper one. Its over 8,000 products and I cant sit here and copy n paste manually. Ill be here till next week trying. I would like to know if a fellow black hat member happens to know of a easier way to either copy down the line of columns with the wrong mapped item and paste it to the next column, It only some in different rows of the column that are mapped wrong not a whole entire column.

Or if you know anything about Product Feed upload manually with text then that could answer this problem as well. I am really looking for help on this topic.

Thanks

Sorry BHW owner, I just realized i placed this thread in the wrong place. I hope you can place it in the right place for me.

You need to learn basic office. It's simple just copy and paste to right cols and rows