Cross posted at Convert an excel file with many fields into one with a few specific fields
Please always add links to cross posts. Please read A message to forum cross posters - Excelguru to understand why this is important
Thx

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post