• Skip to primary navigation
  • Skip to main content
  • Skip to footer

BobbyVoicu.com

Curious about stuff

  • Home
  • About Me
  • Blog / Archive
You are here: Home / Misc / Transpose and Remove Duplicates in Google Sheets (Docs)

Transpose and Remove Duplicates in Google Sheets (Docs)

April 6, 2020 By Bobby Voicu

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!

◀"Natural" Mouse Scroll for Windows 10
Used Lenovo ThinkPad Buying Guide▶

Filed Under: Misc, Tools I Use

>>> If you want to continue the conversation, email me at me at bobbyvoicu dot com

Bobby Voicu

Bobby Voicu writes here from time to time.

Footer

About

I write about things that raise my curiosity. And I’m quite curious about all kinds of things.

For a full “About Me”, go here.

Recent Posts

  • My Bluesky ID: @bobbyvoicu.com
  • Batman is Here, on the Quest – XR Industry News of the Week – Oct. 24
  • XR Industry News of the Week – Oct. 10
  • XR Industry News of the Week – Oct. 4
  • XR News of the Week – September 14th, 2024

Friends

  • Sami the Westie
  • XR Gamer Digest

The CEO Library Collections

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

Copyright © 2025 · 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.