Is there a way to extract the information out of each field that will be listed as headers as reference for the macro?
Please have a look,
3 worksheets.
1) "Raw data"
2) "Output" - reformatting of the raw data
3) "Example" - expected result
Text Extractor.xlsm
Bookmarks