Challenge #19: Excel Record Locator

[ivoller]

Fewer tools with another approach - Not convinced it's an improvement over previous solutions but gave me an opportunity to play with changing Excel input.

Spoiler

Used SQL to union the required data on input, then a simple crosstab to get the output.

[jsdeter]

Posting SOlution

[Oliver]

Solution attached.

[lucasmascarenhas]

Spoiler

[JDelgado]

Jet DB query syntax for querying Excel sheets is not intuitive!

[daniel_ferreira]

Follow my solution file attached...

[KOBoyle]

Solution attached.

[DriveMyData]

Spoiler

[StevenBetts]

Here's my solution :)

Spoiler

[ponraj]

Uploading my solution.