https://www.sqlservercentral.com/forums/topic/cross-tabs-and-pivots-part-1-converting-rows-to-columns/page/3
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns – SQLServerCentral Forums
Nov 23, 2021 - Cross Tabs and Pivots, Part 1 – Converting Rows to Columns Forum – Learn more on SQLServerCentral
cross tabspivotspartconvertingrows