Convert Certain Rows into Columns

Closed
sandy - Jul 4, 2010 at 01:44 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 4, 2010 at 04:48 AM
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 January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 4, 2010 at 04:48 AM
what do y ou mean by certain rows. Are you looking for alternate rows or some thing else
0