This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
My current workflow, however's it's messy and not as concise as I would like it to be:
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.