Row Level Sorting

[JonathanRichey]

Is it possible to sort at a row level? The current tab shows how my data is structured, the need tab is my solution. Is this possible to do a row level sort starting with Teacher1 through Teacher10 in Alteryx?

Current:

Student	Teacher 1	Teacher 2	Teacher 3	Teacher 4	Teacher 5	Teacher 6	Teacher 7	Teacher 8	Teacher 9	Teacher 10
Bob	AMANDA	MINDY	PATRICK	MICHAEL	PAUL	ALISON	MILA	CHRISTOPHE	STEPHEN	MADELYN
Bill	CELESTINA	ERIC	BROOKE	AYOTUNDE	ANDREA	JONATHAN	AIDAN	AUREA	ALBANETTE	STEPHEN
Erick	KEVIN	MCGWIRE	JOHNELL	JOSEPH	ALEXA	GARY	BRICE	DEENA	DOUGLAS	MONIQUE
Tyrion	ELIZABETH	JASON	SHUBIN	CHRISTOPHE	KYLE	RICHARD	JAMES	JEFFREY	RICHARD	IVAN
Cersei	HANA	PHILIP	BIBBY	CHARLES	KIMBERLY	DAVID	DAVID	RAGHAVENDRA	AMBER	MARGERY
Jaime	KATHY	EMMY	MARGARET	BRIAN	MICHAEL	CAROLE	RAYMOND	GLENN	ELISE	FRANCES

Need:

Student	Teacher 1	Teacher 2	Teacher 3	Teacher 4	Teacher 5	Teacher 6	Teacher 7	Teacher 8	Teacher 9	Teacher 10
Bob	ALISON	AMANDA	CHRISTOPHE	MADELYN	MICHAEL	MILA	MINDY	PATRICK	PAUL	STEPHEN
Bill	AIDAN	ALBANETTE	ANDREA	AUREA	AYOTUNDE	BROOKE	CELESTINA	ERIC	JONATHAN	STEPHEN
Erick	ALEXA	BRICE	DEENA	DOUGLAS	GARY	JOHNELL	JOSEPH	KEVIN	MCGWIRE	MONIQUE
Tyrion	CHRISTOPHE	ELIZABETH	IVAN	JAMES	JASON	JEFFREY	KYLE	RICHARD	RICHARD	SHUBIN
Cersei	AMBER	BIBBY	CHARLES	DAVID	DAVID	HANA	KIMBERLY	MARGERY	PHILIP	RAGHAVENDRA
Jaime	BRIAN	CAROLE	ELISE	EMMY	FRANCES	GLENN	KATHY	MARGARET	MICHAEL	RAYMOND

[StephenR]

The Sort tool will do the trick (example attached)

[ponraj]

Here is the sample workflow for your case.  Hope this is helpful. 

Workflow

[myastarling]

That's a really nice solution to this -- I'm going to file this away for future reference. The one thing I noticed is that if the teacher names are duplicated then the duplications are excluded. May I suggest a small modification to include these dupes? Rather than grouping by Value, concatenate instead and then parse into rows to keep the duplicates --

[myastarling · Accepted solution]

sorry for the duplicate post -- for some reason it wouldn't let me post my workflow unless I replied directly to the original post. I've attached my slight modification.

[JonathanRichey]

@myastarling is it possible to share your workflow?

Thanks!

[myastarling]

@JonathanRichey

did my second post come through? For some reason I was unable to post a workflow responding to ponraj's response, so I added a response to the OP - let me know if it isn't visible on your end.

[JonathanRichey]

@myastarling yes. It showed right after I asked to share your workflow. Thanks @ponraj and @myastarling for the solution!

[myastarling]

whoops! my apologies! it needs one more sort tool immediately after the Transpose tool (sort by Value - ascending) - otherwise it reassembles everything back into the original order.

[JonathanRichey]

Updated to include sort after transpose. Thanks!