I asked this a year ago and is the only question still waiting fro reply.
https://www.msofficeforums.com/excel...e-arrange.html
I want to make little bit easier this time.
I want to compare value of any column with respect to specific column.
for example I have This.
Code:
10.0 10.1
10.2 12.4
10.4 13.5
10.6 14.4
10.8
11.0
11.2
11.4
11.6
11.8
12.0
12.2
12.4
12.6
12.8
13.0
13.2
13.4
13.6
13.8
14.0
14.2
14.4
Want to convert it to this.
Code:
10.0 10.1
10.2
10.4
10.6
10.8
11.0
11.2
11.4
11.6
11.8
12.0
12.2
12.4 12.4
12.6
12.8
13.0
13.2
13.4 13.5
13.6
13.8
14.0
14.2
14.4 14.4
or say this If better feasible
Code:
10.0 10.1 10.1
10.2 12.4
10.4 13.5
10.6 14.4
10.8
11.0
11.2
11.4
11.6
11.8
12.0
12.2
12.4 12.4
12.6
12.8
13.0
13.2
13.4 13.5
13.6
13.8
14.0
14.2
14.4 14.4