Concatenate with SELECT *
The CONCAT function requires passing column names explicitly and there is no such thing as CONCAT(*).

On the other hand, PIVOT requires an explicit definition of the columns you are pivoting: if you are doing it dynamically, you probably have a variable that holds the names of the columns you are pivoting on and you could use the same variable in dynamic SQL with the CONCAT function.