• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

BobbyVoicu.com

  • Home
  • Entrepreneurship Articles
  • Startup Videos
  • About Me
  • Blog / Archive

Transpose and Remove Duplicates in Google Sheets (Docs)

April 6, 2020 By Bobby Voicu Leave a Comment

I’ve had to do some cleaning for a list of numbers recently and I used Google Docs for that. Of course, I used the Excel equivalent, Google Sheets.

Since it’s not the first time I looked for this information, I thought I would put it here, in case I ever need it again. And in case anybody else needs it.

How to TRANSPOSE cells in Google Docs (Sheets)

  • Use this function: =TRANSPOSE(A1:C11)
  • Change A1 and C11 with the top left and bottom right, respectively. You can see how in the image below.

How To Remove Duplicates in Google Docs (Sheets)

This is even simpler.

  • Just select all your fields (or not, since you also have the option of remove duplicates in the entire sheet).
  • Go to Data -> Remove Duplicates in the top menu (see the image below).
  • Then you are taken to another window, where you can select exactly where you want to remove the duplicates.
  • And that’s it!

Filed Under: Misc, Tools I Use

Bobby Voicu

Bobby Voicu writes here from time to time.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Friends

  • Andrei Rosca
  • Dr. Alexandra Mircea
  • Emi Gal
  • Miruna Sfia
  • Rød Mallo Leiva
  • Sami the Westie
  • Vlad Balan
  • Vladimir Oane

The CEO Library Collections

  • Best Leadership Books
  • Best Productivity Books
  • Women Entrepreneur Books

Copyright © 2021 · Privacy Policy · Disclaimer

We use cookies to enhance your experience. By clicking "Ok" or by continuing to use the site, you agree to this use of cookies and data. Ok