Hello - I have the following list of values I would like to search for in a dataset:
The dataset I would like to search looks like this
I would like to extract from here the contents of the matching cells (date ranges), as well as the company name in the row above each match, and list them horizontally, with the answer appearing as:
January |
February |
March |
April |
May |
The dataset I would like to search looks like this
Experience: |
ACME Inc |
January 5 - March 30 |
Acme Corp |
February 6 - May 13 |
gibberish |
gibbering |
Random Partners |
April 6 - January 28 |
gibberish |
I would like to extract from here the contents of the matching cells (date ranges), as well as the company name in the row above each match, and list them horizontally, with the answer appearing as:
ACME Inc | January 5 - March 30 | Acme Corp | February 6 - May 13 | Random Partners | April 6 - January 28 |