Currently, when a column in the Spreadsheet is filtered and you paste a value in the cells of another column, the pasted value will apply for all rows between the filtered rows as well. That is similar to the Transpose paste option in Excel. Kindly change the default behavior so that the pasted values will apply for the filtered rows only, as in Excel. Additionally, implement an Transpose option that could be enabled/disabled.