Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEADeceptively tricky...
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