I've a Google Sheet. I've transposed the data. Is there a way to also transpose any notes/comments that are attached to cells in the original data set?
Google Sheets have two different features for handling notes/comments, one is called notes, the other is called comments. While both could be attached to cells they could behave differently. Comments shows the profile picture of the user and have additional features like mentioning, mark as resolved, etc. that notes haven't.
- Copy-Paste : Only notes are included on the new position
- Copy-Paste as transposed : Only notes are included on the new position
- Cut-Paste : Both notes and comments are moved to the new position.
- Using formulas to transpose a range : Notes and comments aren't included
Google Apps Script could be used to transpose ranges and it will include notes but not comments.
Notes: Some documentation use the term comment to refer to notes.
.moveTo(target) is able to move comments
So you can create a function in Tools > Script editor who'll transpose cells and keep the comments.