flipping (not transposing) data?

I have two very long columns of data. I would like to flip them. For example, there are 6028 lines of data. I would like to see data on line 6028 on line 1 and data from line 6027 on line 2, so on and so forth. Can this be done?

Thanks

Hi

Try the following code.

Please Login or Register  to view this content.

This is for 50000 lines and two columns, just substitute your values appropriately.

Regards

Jeff

thanks, the numbering of columns worked easily.