Hi, I have a data set that looks similar to this; Scale ID Value -13 A 123 -12 A 473 -11 A 391 -6 A 127 -5 A 237 -4 A 342 -2 A 186 3 A 98.9 4 A 343 5 A 93 6 A 162 10 A 735 11 A 345 etc How can I insert duplicate rows so I have a continuous scale of 0 to 11 without affecting any of the negative data, eg transform the data into; Thanks in advance. Scale ID Value -13 A 123 -12 A 473 -11 A 391 -6 A 127 -5 A 237 -4 A 342 -2 A 186 0 A 186 1 A 186 2 A 186 3 A 98.9 4 A 343 5 A 93 6 A 162 7 A 162 8 A 162 9 A 162 10 A 735 11 A 345 etc (Later on in the data it moves to ID B etc.) So where new rows are inserted into the data it copies the values of the row above, except for scale which increase;
... View more