Here is what you requested.....

There are probably better and more efficienct ways of doing it... but at least this works and will get you started.

AssColOutput.xlsm