see your replies to similar issues and thought of looking for help with you.

I have an excel sheet which is exported from a crystal report. It is product details.
Every product has one row and go up to 36-40 columns. There are around 1000 rows.
After export, the data after the column 30 goes to next row and sometime to a third row as well.

So instead of one row for each product, some product info is on 3 rows, some on 2 rows and some are on 1 row(that is due to lack of data in the last columns).
I am copying and pasting the date from the row below to the last last column of the row above manually to do some analysis.

Is there anything I could do to correct this? I appreciate all the help you could provide.

Thanks