Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

fellow GIS-ers :)!
I've been trying to find a tool to do the opposite to what the "pivot table" tool does but I dont thin there is any tools for that. I have a raster data set derived from Landsat imagery with a only a single value per pixel. In Arcmap the table for this file is organize in a way that it has two fields (apart from the ID field). 1. count, and 2. value, or in other words all of the one-to-one relations were joined into one-to-many relations. i need to find a way to go back to the one-to-one relations "form". Which by looking at how a pivot table tool works is kind of the opposite. please any help would be much appreciated.

             **how it is**                                **how i need it**
     ID    Count     Value                         ID      Value
     1      3          75                          1        75
     2      4          65                          2        75
                                                   3        75
                                                   4        65
                                                   5        65
                                                   6        65
                                                   7        65


share|improve this question
What exactly are you trying to achieve? Do you want an attribute table with a row for every pixel? – Devdatta Tengshe Apr 27 '13 at 5:11
yes! in other words thats what i need – Fabian Apr 27 '13 at 15:40
Rasters attribute tables don't work that way. You can get the cell value at a point using… – Devdatta Tengshe Apr 27 '13 at 16:25

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.