Options

# "[SOLVED] Transposing Data Loop"

Hi,

Another simple question - having trouble getting acquainted with all the functions - it's going to take some time.

I've got a list of text as follows:

x1

y1

z1

x2

y2

z2

x3

y3

z3

And I want to transpose it to the following:

x1 y1 z1

x2 y2 z2

x3 y3 z3

I've managed to calculate the amount of iterations successfully using macros but I'm struggling to get it moving through the list of values. I've tried using a loop with a nested transpose process but something is missing.

Any help would be much appreciated.

Thanks again!!

Cheers,

Rowan

Another simple question - having trouble getting acquainted with all the functions - it's going to take some time.

I've got a list of text as follows:

x1

y1

z1

x2

y2

z2

x3

y3

z3

And I want to transpose it to the following:

x1 y1 z1

x2 y2 z2

x3 y3 z3

I've managed to calculate the amount of iterations successfully using macros but I'm struggling to get it moving through the list of values. I've tried using a loop with a nested transpose process but something is missing.

Any help would be much appreciated.

Thanks again!!

Cheers,

Rowan

Tagged:

0

## Answers

15Contributor II47Contributor III've managed to generate a "group" number, group 1,2&3 for each of the variables - still wont pivot.

Could you perhaps post an example?

Updated data:

Id Group Att1

1 1 x1

2 1 y1

3 1 z1

4 2 x2

5 2 y2

6 2 z2

7 3 x3

8 3 y3

9 3 z3

Or would this be more correct:

Id Group Att1

1 1 x1

2 2 y1

3 3 z1

4 1 x2

5 2 y2

6 3 z2

7 1 x3

8 2 y3

9 3 z3

Thanks.

Cheers,

47Contributor IIhttp://rapid-i.com/rapidforum/index.php/topic,6602.0.html