Challenge #309: Movie Catalogue

[AYXAcademy]

A solution to last week’s challenge can be found here.

The dataset is a short sample of Rotten Tomatoes's list of 100 best movies written by women. These are highly Certified Fresh films (nothing on the list falls below 94%) whose screenplay credit goes in part or fully to women.

The challenge is to create a PDF catalogue to create a list of 10 movies written by women. The catalogue must contain: name, cover, writer, synopsis, critics consensus, starring, director. 

Extra cookies if you solve this challenge using the Tile tool!

[mmotte628]

Do we have one that includes the output? Mine isn't showing that. 

[AYXAcademy]

@mmotte628 Thank you for letting us know it was missing, the file has been updated to include the output.

[patrick_digan]

Spoiler

Here's my take:

Here's a sample of the pdf:

[RolandSchubert]

Spoiler

I would prefer  the "Make Columns" option

[joelmiller66]

Spoiler

[Reesetrain2]

All,

Spoiler

This was a fun one!
-I used:
2 Crosstabs
4 Select Tools
1 Dynamic Rename
4 Text to Columns ( I used these versus using a Multi-Row formula to avoid any Custom Code, which is a thing of mine)
1 Download Tool
1 Basic Table to finish up.
-Cheers!

Matt 

[TonyA]

Here's my solution

Spoiler

Tried to keep it simple so I didn't use RegEx to remove the labels from the cells.

[alexnajm]

I want those extra cookies! 😊🍪

Spoiler

[xxreese]

First time I used a 'blob'