Use TEXTJOIN function in Excel- Smart Solution using a real example

Assume that you have a list of items for many orders, and you need a formula to get the item numbers for each sales order separated by comma.
The smart solution is to use TEXTJOIN function!
Six new calculations have been added since last year for Office 365 subscribers. One of those, the TEXTJOIN function, is proving to be more flexible and more powerful than it originally appeared. When TEXTJOIN was introduced in 2017, it seemed like Microsoft was trying to improve deficiencies in the CONCATENATE function. But there’s more to it.