Hello sharma06shubham and welcome to the forum.
Try this in columns F:I
In F2 fill down until you get blanks. Then array enter this in G2 fill down and across. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
1 |
CELL ID |
VALUE 1 |
VALUE 2 |
|
|
CELL ID |
VALUE 1 |
VALUE 2 |
|
2 |
54900, 41049 |
-111.55 |
-81.9 |
30 |
|
54900 |
-111.55 |
-81.9 |
30 |
3 |
13238, 14960 |
-89.4 |
-74.32 |
|
|
41049 |
-111.55 |
-81.9 |
30 |
4 |
56990, 41327 |
-106.99 |
-98.27 |
|
|
13238 |
-89.4 |
-74.32 |
|
5 |
56285, 6436 |
-68.87 |
-74.41 |
|
|
14960 |
-89.4 |
-74.32 |
|
6 |
17297, 49055 |
-106.63 |
-95.84 |
|
|
56990 |
-106.99 |
-98.27 |
|
7 |
|
|
|
|
|
41327 |
-106.99 |
-98.27 |
|
8 |
|
|
|
|
|
56285 |
-68.87 |
-74.41 |
|
9 |
|
|
|
|
|
6436 |
-68.87 |
-74.41 |
|
10 |
|
|
|
|
|
17297 |
-106.63 |
-95.84 |
|
11 |
|
|
|
|
|
49055 |
-106.63 |
-95.84 |
|
Bookmarks