Transform rows in columns

Michele Tufano

It would be very useful to have a function or automation that allows to copy (based on a selection criterion), the values in the rows of a column and transpose them on a single row of another sheet, on a corresponding number of columns.

Example: In a source sheet I have a column with an identifier code; I want to copy all the values in the rows of another column that match that identifier code and paste them onto a row of a target sheet in which the field of the first column contains the selection criterion (a given identifier code) and the fields of the following columns the n values that were found on the source sheet.