Best way of handling strings

[Ashley.w]

Hi

I am have trouble handling strings.

I would like to know the best way of transposing strings for uploading to spreadsheet file

for example I have a series of comma seperated strings:

string a, 1,2,3,4,5,6,7,8,9,10

string b, 2,4,6,8,10,12,14,16,18,20

string c, 3,6,9,12,15,18,21,24,27,30

string d, 4,8,12,16,20,24,28,32,36,40

etc.

I would like to transpose these strings to a column format:

string a, string b, string c, string d

1,2,3,4

2,4,6,8

3,6,9,12

4,8,12,16

5,10,15,20

6,12,18,24

7,14,21,28

8,16,24,32

9,18,27,36

10,20,30,40

Is there an easy way of doing this so I can manage data better?

Many thanks

Ash

[Will.D]

I believe if you were to build your strings into an array, and then set the "Write to Spreadsheet File"'s 'Transpose' input to true, you should get what you're looking for.

[Ashley.w]

Excellent!

I knew there was an easy way.

Thanks

Ash