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

BobbyVoicu.com

I'm curious about stuff

  • Home
  • Entrepreneurship Articles
  • Startup Videos
  • 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 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!

◀"Natural" Mouse Scroll for Windows 10
Who should be the main person in a startup to pitch to an investor? [Video & Transcript]▶

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

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

  • I’m Gonna Live on a Boat
  • Plex on Rasberry Pi 4
  • Foundation: The Official Podcast
  • What is iOS 15 bringing?
  • I want: SteamDeck
  • SD Card formatter for Raspberry Pi compromised SD cards
  • Brandolini’s law or the bullshit asymmetry principle
  • Chat etiquette: Hi every time you start?
  • 5th Ocean: The Southern Ocean
  • The Impact of Work from Home

Friends

  • Dr. Alexandra Mircea
  • FreeBusy Meeting Scheduler
  • Miruna Sfia
  • PS Play Romania
  • Rød Mallo Leiva
  • Sami the Westie
  • Vlad Balan

The CEO Library Collections

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

Copyright © 2023 · Privacy Policy · Disclaimer