Results 1 to 39 of 39

[Solved] Coordinate Data

Threaded View

  1. #1
    Registered User
    Join Date
    08-06-2011
    Location
    Decatur GA
    MS-Off Ver
    Excel 2010
    Posts
    25

    [Solved] Coordinate Data

    Hi, All

    These are likely simple questions, but I've been banging my head for hours with tutorials with no joy.

    I have a csv file containing a Z coordinate only. I need to add x and y, whereas cell A1 is 1,1,"Z value", cell B1 is 1,2,"Z value", cell A2 is 2,1,"Z value". I have 480 rows and 640 columns of data, so the last cell should be 480,640,"Z value".

    I've attached a screenshot showing in A1 the desired result. I appreciate any help.

    EDIT

    To clarify, the X and Y coordinates will simply be the cell number with a comma separator. Hope that helps. Oh, and this would be my first post, so if I didn't ask properly, please let me know. Thanks.
    Attached Images Attached Images
    Last edited by bsjordan; 08-06-2011 at 09:05 PM. Reason: Clarity

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1