List Copy Paste Concatenate

[kingsolo]

Hello Experts,

I have a sheet that I need to figure out how to automate:
- I need to copy the Attendees Column (Could be upwards of 500) to Output A2
- Sort alphabetically
- If the level is below the level threshold listed, the person needs to report as NAME,LEVEL
- If there is anything in the percentage column, the person needs to report as NAME,PERCENTAGE
- If the level is below the level threshold AND there is something in the percentage column, the person needs to report as NAME,LEVEL,PERCENTAGE
- The next blank after the list of attendees should be 10 dashes (----------)
- Then copy all items (Maximum 10) from the Additional Info list to the first blank cell below the dashes

I have put an "Expected Outcome" tab to hopefully clear up any questions about how the report has to be submitted.

Thanks in advance.

https://1drv.ms/x/s!Aoa335Q8qKqRhiGPQKuNN3YFnKa0

 

[kingsolo]

That got me! Thank you so much for your time & assistance!

 

[Fluff]

Glad to help & thanks for the feedback