Convert Certain Rows into Columns

Closed
sandy - 4 Jul 2010 à 01:44
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 4 Jul 2010 à 04:48
Hello,

Hi all. I need help on how to convert excel data from certain rows into columns. Let say I have data in this way:

x0
y0
x1
y1
x2
y2
.
.
.
.

I would like to convert them into this way:
x0 y0
x1 y1
x2 y2
. .
. .

Anyone have idea how to do it?Hope to get reply...thanks alot :)


Regards,
Sandy

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
4 Jul 2010 à 04:48
what do y ou mean by certain rows. Are you looking for alternate rows or some thing else