Sign in to submit new ideas and vote
Get Started

Transform rows in columns


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.

5 votes

Idea Submitted · Last Updated