I would like to modify a Spreadsheet that is preconfigured to export from the software in the below way:
then I would like it to format in the following way:
The person may have more than one Badge ID so it could be 2 or 3 or 4 like the Cray, Acie has, it just depends.
don't know if there is a way to produce this? Maybe by a macro or VBA? something? I have perhaps, thousands.