P
Param Dhillon
Hi,
I have data which is in the format below called "Before Data" and I am
trying to get it to "After Data" format. I can do some programming if given
some advice.
As you notice I am trying to repeat data from
ID Long Lat
1 9.5 4
where 4 is number of times value 9.5 is included in Value column of "After
data"
Any help would be appreciated.
Before Data
ID Long Lat
1 9.5 4
2 -118.727 37.81862
3 -118.728 37.81875
4 -118.731 37.81907
5 -118.735 37.81995
6 10.5 3
7 -118.743 37.82292
8 -118.744 37.82338
9 -118.748 37.8261
After Data
ID Long Lat Value
1 9.5 4
2 -118.727 37.81862 9.5
3 -118.728 37.81875 9.5
4 -118.731 37.81907 9.5
5 -118.735 37.81995 9.5
6 10.5 3
7 -118.743 37.82292 10.5
8 -118.744 37.82338 10.5
9 -118.748 37.8261 10.5
I have data which is in the format below called "Before Data" and I am
trying to get it to "After Data" format. I can do some programming if given
some advice.
As you notice I am trying to repeat data from
ID Long Lat
1 9.5 4
where 4 is number of times value 9.5 is included in Value column of "After
data"
Any help would be appreciated.
Before Data
ID Long Lat
1 9.5 4
2 -118.727 37.81862
3 -118.728 37.81875
4 -118.731 37.81907
5 -118.735 37.81995
6 10.5 3
7 -118.743 37.82292
8 -118.744 37.82338
9 -118.748 37.8261
After Data
ID Long Lat Value
1 9.5 4
2 -118.727 37.81862 9.5
3 -118.728 37.81875 9.5
4 -118.731 37.81907 9.5
5 -118.735 37.81995 9.5
6 10.5 3
7 -118.743 37.82292 10.5
8 -118.744 37.82338 10.5
9 -118.748 37.8261 10.5