Creating a query or function that concatenates row text and adds new columns by comparing a field

This is probably a simple thing to do, but I'm all thumbs.      In the attached sample file, order details are either one or multiple rows long.   If the SKU/Item numbers match for a given set of r...