Challenge #337: Create a New List from an Existing List

[jassik]

Here is the new list

[ricki]

Spoiler

 

[ZMcCain]

The wording in this "Challenge" is very misleading. "Categories (Action and Adventure, Documentaries, etc.)" - this information is found in the column "listed_in", implying this is the "Categories" column needed for the output. Instead, listed in the "answer" to this challenge is a column called "Category" (inconsistent with the requested list) that includes none of the information listed in its example, but instead filled only with "International Movies". This inconsistency takes the one challenging aspect of this "Weekly Challenge" out, and replaces it with a formula tool that sets Category to International Movies. 

[skvaughn]

I had selected "use dictionary order" but the solution did not. Wouldn't this be the correct way of sorting the duration?

[skvaughn]

Solution

[dkungu]

solution

[RasmusFormo]

Spoiler

[leonardstarrk]

Pretty easy! 

[SzymonDK]

Spoiler

[Rhys_Cooper]

Good Challenge 

Spoiler