Repetition in Columns to Rows

Question

Hello,

I have flight data that are categorized in column B "Routing", I would like to have this information going across horizontally as Flight In , Time, Route then Flight Out, Time, Route, and then Flight In 2, etc.

In addition, after the the data have been transposed horizontally, any repetitions of rows after the first row can be deleted. As well as, one person can have up to 15 occurrences of fly in and fly out, so how do I concise it and not have an output that have so many columns?

Input

Preferred Output:

My current workflow, however's it's messy and not as concise as I would like it to be:

Flight Example.xlsx

RobertOdera · Accepted Answer

Hi, @cchueh

Slightly different result presentation (due to limitations seeding field values into field name).

Still, try this.

Please mark as a solution if acceptable + like if helpful.

str_name_key, Date, Dir (in or out), Time, Route

The workflow is attached.

Cheers!

Blake · Accepted Answer

Hi @cchueh - I took a little bit different approach than @RobertOdera but I think it will still work. One of the great things about Alteryx is the ability to solve the same problem in many different ways.