[Solved] Coordinate Data

**bsjordan** · 08-06-2011, 06:01 PM

Thanks for the reply, shg. We already have that accomplished. What I need is to convert this:

--A--- --B--- --C--- --D---
1 1,1,47 1,2,56 1,3,69 1,4,68
2 2,1,15 2,2,31 2,3,90 2,4,55
3 3,1,93 3,2,68 3,3,44 3,4,23
4 4,1,36 4,2,75 4,3,44 4,4,85

to this:
1 1,1,47
2 2,1,15
3 3,1,93
4 4,1,36
5 1,2,56
6 2,2,31
7 3,2,68
8 4,2,75
9 1,3,69
...and so on

Basically, append B to A, C to B, D to C, etc...

Can you help with this?

**shg** · 08-06-2011, 06:10 PM

       --A--- --B--- --C--- D -E-- --F---
   1   1,1,47 1,2,56 1,3,69   Line Value 
   2   2,1,15 2,2,31 2,3,90      1 1,1,47
   3   3,1,93 3,2,68 3,3,44      2 2,1,15
   4   4,1,36 4,2,75 4,3,44      3 3,1,93
   5                             4 4,1,36
   6                             5 1,2,56
   7                             6 2,2,31
   8                             7 3,2,68
   9                             8 4,2,75
  10                             9 1,3,69
  11                            10 2,3,90
  12                            11 3,3,44
  13                            12 4,3,44

In F2 and down,

=INDEX($A$1:$C$4, MOD(E2-1, ROWS($A$1:$C$4)) + 1, INT((E2-1) / ROWS($A$1:$C$4)) + 1)