0

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?

0

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.

-1

Check out this thread on Stackoverflow

.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.

  • Thank you for your help here. I'm not so familiar with scripting etc. Something I may need to learn! Shame there's now easy way. – Swotty Aug 5 at 8:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.