Collating data in several columns

I really hated the delay, and coerced some simpler code to do the work.

If the data is this wide or smaller, just pressing the GetTeams button on this version and it will quickly build your chart.

Thanks, SHG, I incorporated your UDF into this version as well so, IFERROR formulas are in effect. Reading? Oh my.... that would make things easier, right? Not sure I'm ready to start studying again, hehe.

Hope this solves it for you, Cardiff. If you want to adjust the stuff it's doing in the GetTeams macro, it should be pretty straightforward. You can do it.