The script is available for download in Microsoft Script Browser for Windows PowerShell ISE. You need to install the Script Browser application first, and search for the script sample title.
This T-SQL script will demo how to combine multiple rows into one row by a same column value in SQL Server.
As many people asked how to combine multiple rows into one row by a same column value. The script will demo how to combine by creating a table.
You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery