First of all, I would like to make the following work.
How do I iterate through my array in such a way that the C2 list displays values according to array’s rows? Like so:
List index 0: displays: array row 0.
In other words I want to get:
Index 0: arrayValueEntered1, arrayValueEntered2, arrayValueEntered3
Index 1: arrayValueEntered4, arrayValueEntered5, arrayValueEntered6
Index 2: arrayValueEntered7, arrayValueEntered8, arrayValueEntered9
Thus all values like in the array but separated by a comma.
The only working thing I could come up with was to iterate using “For each XY element” but it obviously does not do what I intended.
I tried to build a while loop since I do not know how many rows there will be and then I nested a for loop since I know that I will have three values in my array in its height. Unfortunately I cannot make it work.
Thus, can you either correct my looping to achieve the desired effect or add a proper way of iterating to achieve what I am aiming at?
My secondary question is related to my goal, which is the most accurate representation of the array in a visual way. I chose to use the list but even if the above works, which even now does not at the moment of writing, I still would not be able to precisely change the values, only whole rows. Would there be a more accurate user interface to manipulate the array in the file so that the user could choose particular values to change?
capx for correction below: