Macro to make one row data to two column data

**luquilla** · 05-31-2013, 03:02 AM

Hi guys I have a series of data organized in a single row:
254 524 542 542 658 652 562 562
they are x and y coordinates, so I need the data to be like this
254 524
542 542
658 652
562 562

I would really appreciate a macro that can do this task

Thanks

**dilipandey** · 05-31-2013, 03:38 AM

Hi luquilla,

You can achieve this using formula:-

for x:-

Formula:

Please Login or Register  to view this content.

for y:-

Formula:

Please Login or Register  to view this content.

see attached file, enter your data in row 1, select both green cells and drag the formula down:-

seperating row data as x y cordinates.xlsx

Regards,
DILIPandey
<click on below * if this helps>

**hulpeloos** · 05-31-2013, 03:39 AM

Please Login or Register  to view this content.

**JOHN H. DAVIS** · 05-31-2013, 06:50 AM

Another: (Assumes your data is in Row 2).

Please Login or Register  to view this content.

Macro to make one row data to two column data

LinkBack

Thread Tools

Rate This Thread

Display

Macro to make one row data to two column data

Re: Macro to make one row data to two column data

Re: Macro to make one row data to two column data

Re: Macro to make one row data to two column data

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions