Challenge #19: Excel Record Locator

[Bluemoon]

Deceptively tricky...

Spoiler

[DuncanT]

Here's my challenge 19 solution

[SueDonim]

Spoiler

Had to learn a few things about using wildcards but here you go :
- Read in data from both spreadsheets by replacing filename with wildcard
  -- Also had to convert to .xlsx as a security patch on my computer would not allow reading .xls for some reason
- Used multi-row tool to number records (off Excel row number by 1 due to header) for each spreadsheet
- Used two filters to read Row 2 (linenumber 1) from both files and to read Row 8 (linenumber 7) from both files
- Used select tool to isolate and rename specific columns
- Used Join to bring the two together

Solution above and attached

[jusdespommes]

Definitely a prettier way of doing it than I did it - but done 🙂

Spoiler

[Assaf_m]

Solution attached,

[aazimh]

Was worried I took the long way but seems like this is how most went about it.