How to join 3 rows in one line - if possible, unsure if transpose or crosstab - PIC attach

[adriennelenker]

Sort of hard to explain, but basically with this

Order ID I	Order Date I	Order Quantity I	Sales I	Ship Mode I
3	10/13/2010	6	261.54	Regular Air
6	2/20/2012	2	6.93	Regular Air
32	7/15/2011	26	2808.08	Regular Air

How do you change it to this

Order ID I

Order Date I

Order Quantity I

Sales I

Ship Mode I

Order ID II

Order Date II

Order Quantity II

Sales II

Ship Mode II

Order ID III

Order Date III

Order Quantity III

Sales III

Ship Mode III

3

10/13/2010

6

261.54

Regular Air

6

2/20/2012

2

6.93

Regular Air

32

7/15/2011

26

2808.08

Regular Air

I'm told it's possible but not sure how. If so, would like to know

1) How to perform this

2) How to achieve the Roman numerals (or other numbers) detailing the exact rows the original data was

1) would be more important

Thanks for the help

[malteryx1]

Here the below solution. There might be a easy solution,if it helps please mark it as a Solved Solution

[gawa]

hi @adriennelenker 

If you have dynamic number of rows, you can try this way.

[aatalai]

Another way would be using 3 select records tool, and choosing one for each row and then appending the data together, however, this solution would not be effiecent if you are looking to scale it