Convert Certain Rows into Columns

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
what do y ou mean by certain rows. Are you looking for alternate rows or some thing else