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