I all ready have a transpose macro. Just need to adjust to your needs. Just checked the file in detail, it's a mix of transpose and expanding. No problem to do that. Depending on desired User Input, the macro could let the user select the range or automatically select al used range in worksheet. I guarantee very fast code for large lists.
I'm an engineer with advanced working knowledge and experience in Excel, VBA and VBA interaction between different software (Word, Excel, Powerpoint, Outlook, Access, Autocad, Project, etc.). Also, have lots of experience with processing very large data files in different formats with VBA (especially data acquisition files), web scraping, Access DB design, management Dashboards, stock and financial worksheets, KPI's, proficient coder in VB.Net, C#, Python, JavaScript (google sheets), VB6.