Sorting in excel ROW to COLUMN?

Question

Hi,
I have some data in a column in which i want to sort as first row in first column, second row in second column third row in first column forth row in second column fifth row in first column sixth row in second column, and so on.

How can I do this?

Can anybody help?

Answer 1

I think I see what you are looking for

There is an Excel file called "2Cols to ColRow" that will convert your table



Check it out here

http://www.anmars.com/Work/?P=596630201



Note that this uses formulas



If this didn't help, please let me know, I can sure do if you send me more details

Answer 2

You could create a column to the right of your data and fill it with a function which gives the value of the required field based on the actual row & column of the location of the function. Then sort on that.

Answer 3

B1 =INDIRECT("A"&ROW(A1)*2-1) copy down list

C1 =INDIRECT("A"&ROW(A1)*2) copy down list