Hi,
I want to use a formula, or set of formulas, for selecting values from a data table were the number of values differ between rows (see attachment). I do not want to cut and paste or use any commands as I need to make this a executable function.
For instance, 9 rows and 21 cols (as in attachment), in the first row i have 21 values, in the 2nd only 4 and in the 3rd I have 5 etc. I want to "merge" these values in order in a single row, i.e. from B2 to V2 (in this case) and then continue with B3 to E3, and B4 to F4 etc, all in a single new row.
So in the table I have a total of 103 values in 9 rows, i want to sort them in a single row, i.e. from e.g. B15 to CZ15 (I think it will be CZ).
[TABLE="class: grid, width: 1492"]
<tbody>[TR]
[TD]Height of cross section[/TD]
[TD] B[/TD]
[TD]C [/TD]
[TD] D[/TD]
[TD] E[/TD]
[TD] F[/TD]
[TD] ...[/TD]
[TD] ..[/TD]
[TD] .[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]0,05[/TD]
[TD="align: right"]0,09[/TD]
[TD="align: right"]0,14[/TD]
[TD="align: right"]0,18[/TD]
[TD="align: right"]0,23[/TD]
[TD="align: right"]0,27[/TD]
[TD="align: right"]0,32[/TD]
[TD="align: right"]0,36[/TD]
[TD="align: right"]0,41[/TD]
[TD="align: right"]0,45[/TD]
[TD="align: right"]0,50[/TD]
[TD="align: right"]0,55[/TD]
[TD="align: right"]0,59[/TD]
[TD="align: right"]0,64[/TD]
[TD="align: right"]0,68[/TD]
[TD="align: right"]0,73[/TD]
[TD="align: right"]0,77[/TD]
[TD="align: right"]0,82[/TD]
[TD="align: right"]0,86[/TD]
[TD="align: right"]0,91[/TD]
[TD="align: right"]1,00[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]1,25[/TD]
[TD="align: right"]1,50[/TD]
[TD="align: right"]1,75[/TD]
[TD="align: right"]2,00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]2,20[/TD]
[TD="align: right"]2,40[/TD]
[TD="align: right"]2,60[/TD]
[TD="align: right"]2,80[/TD]
[TD="align: right"]3,00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]3,17[/TD]
[TD="align: right"]3,33[/TD]
[TD="align: right"]3,50[/TD]
[TD="align: right"]3,67[/TD]
[TD="align: right"]3,83[/TD]
[TD="align: right"]4,00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]4,13[/TD]
[TD="align: right"]4,25[/TD]
[TD="align: right"]4,38[/TD]
[TD="align: right"]4,50[/TD]
[TD="align: right"]4,63[/TD]
[TD="align: right"]4,75[/TD]
[TD="align: right"]4,88[/TD]
[TD="align: right"]5,00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]5,11[/TD]
[TD="align: right"]5,22[/TD]
[TD="align: right"]5,33[/TD]
[TD="align: right"]5,44[/TD]
[TD="align: right"]5,56[/TD]
[TD="align: right"]5,67[/TD]
[TD="align: right"]5,78[/TD]
[TD="align: right"]5,89[/TD]
[TD="align: right"]6,00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]6,07[/TD]
[TD="align: right"]6,14[/TD]
[TD="align: right"]6,21[/TD]
[TD="align: right"]6,29[/TD]
[TD="align: right"]6,36[/TD]
[TD="align: right"]6,43[/TD]
[TD="align: right"]6,50[/TD]
[TD="align: right"]6,57[/TD]
[TD="align: right"]6,64[/TD]
[TD="align: right"]6,71[/TD]
[TD="align: right"]6,79[/TD]
[TD="align: right"]6,86[/TD]
[TD="align: right"]6,93[/TD]
[TD="align: right"]7,00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]7,10[/TD]
[TD="align: right"]7,20[/TD]
[TD="align: right"]7,30[/TD]
[TD="align: right"]7,40[/TD]
[TD="align: right"]7,50[/TD]
[TD="align: right"]7,60[/TD]
[TD="align: right"]7,70[/TD]
[TD="align: right"]7,80[/TD]
[TD="align: right"]7,90[/TD]
[TD="align: right"]8,00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]8,07[/TD]
[TD="align: right"]8,14[/TD]
[TD="align: right"]8,21[/TD]
[TD="align: right"]8,29[/TD]
[TD="align: right"]8,36[/TD]
[TD="align: right"]8,43[/TD]
[TD="align: right"]8,50[/TD]
[TD="align: right"]8,57[/TD]
[TD="align: right"]8,64[/TD]
[TD="align: right"]8,71[/TD]
[TD="align: right"]8,79[/TD]
[TD="align: right"]8,86[/TD]
[TD="align: right"]8,93[/TD]
[TD="align: right"]9,00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]9,16[/TD]
[TD="align: right"]9,33[/TD]
[TD="align: right"]9,49[/TD]
[TD="align: right"]9,65[/TD]
[TD="align: right"]9,82[/TD]
[TD="align: right"]9,98[/TD]
[TD="align: right"]10,15[/TD]
[TD="align: right"]10,31[/TD]
[TD="align: right"]10,47[/TD]
[TD="align: right"]10,64[/TD]
[TD="align: right"]10,80[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10,8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thanks!
Fredrik
I want to use a formula, or set of formulas, for selecting values from a data table were the number of values differ between rows (see attachment). I do not want to cut and paste or use any commands as I need to make this a executable function.
For instance, 9 rows and 21 cols (as in attachment), in the first row i have 21 values, in the 2nd only 4 and in the 3rd I have 5 etc. I want to "merge" these values in order in a single row, i.e. from B2 to V2 (in this case) and then continue with B3 to E3, and B4 to F4 etc, all in a single new row.
So in the table I have a total of 103 values in 9 rows, i want to sort them in a single row, i.e. from e.g. B15 to CZ15 (I think it will be CZ).
[TABLE="class: grid, width: 1492"]
<tbody>[TR]
[TD]Height of cross section[/TD]
[TD] B[/TD]
[TD]C [/TD]
[TD] D[/TD]
[TD] E[/TD]
[TD] F[/TD]
[TD] ...[/TD]
[TD] ..[/TD]
[TD] .[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]0,05[/TD]
[TD="align: right"]0,09[/TD]
[TD="align: right"]0,14[/TD]
[TD="align: right"]0,18[/TD]
[TD="align: right"]0,23[/TD]
[TD="align: right"]0,27[/TD]
[TD="align: right"]0,32[/TD]
[TD="align: right"]0,36[/TD]
[TD="align: right"]0,41[/TD]
[TD="align: right"]0,45[/TD]
[TD="align: right"]0,50[/TD]
[TD="align: right"]0,55[/TD]
[TD="align: right"]0,59[/TD]
[TD="align: right"]0,64[/TD]
[TD="align: right"]0,68[/TD]
[TD="align: right"]0,73[/TD]
[TD="align: right"]0,77[/TD]
[TD="align: right"]0,82[/TD]
[TD="align: right"]0,86[/TD]
[TD="align: right"]0,91[/TD]
[TD="align: right"]1,00[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]1,25[/TD]
[TD="align: right"]1,50[/TD]
[TD="align: right"]1,75[/TD]
[TD="align: right"]2,00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]2,20[/TD]
[TD="align: right"]2,40[/TD]
[TD="align: right"]2,60[/TD]
[TD="align: right"]2,80[/TD]
[TD="align: right"]3,00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]3,17[/TD]
[TD="align: right"]3,33[/TD]
[TD="align: right"]3,50[/TD]
[TD="align: right"]3,67[/TD]
[TD="align: right"]3,83[/TD]
[TD="align: right"]4,00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]4,13[/TD]
[TD="align: right"]4,25[/TD]
[TD="align: right"]4,38[/TD]
[TD="align: right"]4,50[/TD]
[TD="align: right"]4,63[/TD]
[TD="align: right"]4,75[/TD]
[TD="align: right"]4,88[/TD]
[TD="align: right"]5,00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]5,11[/TD]
[TD="align: right"]5,22[/TD]
[TD="align: right"]5,33[/TD]
[TD="align: right"]5,44[/TD]
[TD="align: right"]5,56[/TD]
[TD="align: right"]5,67[/TD]
[TD="align: right"]5,78[/TD]
[TD="align: right"]5,89[/TD]
[TD="align: right"]6,00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]6,07[/TD]
[TD="align: right"]6,14[/TD]
[TD="align: right"]6,21[/TD]
[TD="align: right"]6,29[/TD]
[TD="align: right"]6,36[/TD]
[TD="align: right"]6,43[/TD]
[TD="align: right"]6,50[/TD]
[TD="align: right"]6,57[/TD]
[TD="align: right"]6,64[/TD]
[TD="align: right"]6,71[/TD]
[TD="align: right"]6,79[/TD]
[TD="align: right"]6,86[/TD]
[TD="align: right"]6,93[/TD]
[TD="align: right"]7,00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]7,10[/TD]
[TD="align: right"]7,20[/TD]
[TD="align: right"]7,30[/TD]
[TD="align: right"]7,40[/TD]
[TD="align: right"]7,50[/TD]
[TD="align: right"]7,60[/TD]
[TD="align: right"]7,70[/TD]
[TD="align: right"]7,80[/TD]
[TD="align: right"]7,90[/TD]
[TD="align: right"]8,00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]8,07[/TD]
[TD="align: right"]8,14[/TD]
[TD="align: right"]8,21[/TD]
[TD="align: right"]8,29[/TD]
[TD="align: right"]8,36[/TD]
[TD="align: right"]8,43[/TD]
[TD="align: right"]8,50[/TD]
[TD="align: right"]8,57[/TD]
[TD="align: right"]8,64[/TD]
[TD="align: right"]8,71[/TD]
[TD="align: right"]8,79[/TD]
[TD="align: right"]8,86[/TD]
[TD="align: right"]8,93[/TD]
[TD="align: right"]9,00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]9,16[/TD]
[TD="align: right"]9,33[/TD]
[TD="align: right"]9,49[/TD]
[TD="align: right"]9,65[/TD]
[TD="align: right"]9,82[/TD]
[TD="align: right"]9,98[/TD]
[TD="align: right"]10,15[/TD]
[TD="align: right"]10,31[/TD]
[TD="align: right"]10,47[/TD]
[TD="align: right"]10,64[/TD]
[TD="align: right"]10,80[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10,8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thanks!
Fredrik