How to rearrange this table?

[richleeb2]

I'd like to change the formatting of this table to be vertical, grouped by Sample Name.  The actual table has 673 fields all in the same arrangement (Name, order, name, order, etc.  These column headers are all different for example task name1, order 1, task name 2, order 2, etc).

Sample Name	Task Name	Task Order	Subtask Name	Subtask Order
Sample 1	Task 1	1	Subtask 1	1.1
Sample 2	Task 1	1
Sample 3	Task 2	1	Subtask 1	1.1
Sample 4	Task 1	1	Subtask 2	1.1

Desired Result

Sample Name	Task Name	Task Order
Sample 1	Task 1	1
Sample 1	Subtask 1	1.1
Sample 2	Task 1	1
Sample 3	Task 2	1
Sample 3	Subtask 1	1.1
Sample 4	Task 1	1
Sample 4	Subtask 2	1.1

[cjaneczko]

 You can use the Arrange tool to accomplish this.

[kamal03]

Hi You can also use the basic select tool to arrange your columns.

Hers is the workflow for the same

[AndrewDMerrill · Accepted solution]

The solutions mentioned above will both work on the sample data as described, but if I'm reading the requirements correctly, there are over 600 columns that need to be transposed down to just 2 columns. Here is a way to do just that assuming my reading is correct: