Hi there, I need some help with Excel.
I have a function as below, where "1" and "2" and so on corresponds to
4 different numbers.
1 52
1 55
1 34
1 22
2 44
2 29
2 12
2 29
Since I need a unique value to correspond to each number in the right
collumn, I need to 'distribute' the "1" and "2" by adding 0.25 to each
subsequent number, as shown below.
1.00 52
1.25 55
1.50 34
1.75 22
2.00 44
2.25 29
2.50 12
2.75 29
Does anyone know how to do that?
Thanks!
Natalie
Bookmarks