Google Sheets transpose paste: check six text cells

Google Sheets transpose paste changes the orientation of a copied block. By the end of this walkthrough, you can turn the text-only rectangle A1:C2 into a three-row, two-column layout at E1:F3 in the same spreadsheet, check every destination cell and save a short record of the result.

Updated: 19 October 2026

What will this small transpose exercise produce?

Imagine a studio coordinator who has a horizontal description of one practice item but wants a vertical reference card. The useful output is not a new report or a calculation. It is a different arrangement of the same six text entries, with a precise map that another person can inspect.

Transposing means exchanging the row and column directions. Entries that run across the first source row should run down the first destination column. The second source row becomes the second destination column. This geometric expectation gives you something stronger to check than whether the result looks generally tidy.

Our input labels and record are fictional exercise material. They are not Anar’s implementation or a customer example. No signed-in paste, clipboard, save, reopening or timed trial was performed for this article. The expected mapping is derived from the sample; it is not an observed screenshot or a reported successful account operation.

The Gemini in Sheets guide addresses creating and reviewing tables with an assistant. This exercise needs no AI request. Keep it limited to native transposed paste for a fixed text block. Do not add formulas, charts or a larger reporting project just to make the exercise seem more substantial.

Create a practice file and enter the source text

Open Google Sheets on a computer using an account you are allowed to use. Start with a separate practice spreadsheet rather than an operational file. Google’s file-creation guidance describes creating a file from the Sheets home screen. Give the practice file a distinctive name by editing its name at the top.

For example, choose Text orientation practice. Record that name and the place from which you expect to find it again. Naming the file is preparation, not evidence that persistence has been tested. The file-creation source supports this setup context; it is not a second independent confirmation of transposed paste.

Enter Code into A1, Item into B1 and Unit into C1. On the next row enter P1 in A2, Notebook in B2 and each in C2. All six entries are deliberately plain text. Type them into their separate cells rather than assuming that copying an HTML table from this page will populate the grid correctly.

Click outside the cell after typing. Google’s file guidance specifically notes clicking outside a typed cell to save in Sheets. Still, do not mark your own save or reopening check complete merely because the documentation describes the behavior. Those fields in your record need actual inspection of your practice file.

Check the entire destination before copying

The source occupies two rows and three columns. After exchanging directions, it needs three rows and two columns. For this exercise that destination is E1:F3, with column D left between the two blocks. The source and destination must not overlap. Do not use this as a whole-sheet operation.

Inspect E1, F1, E2, F2, E3 and F3 individually. All six must be empty. If any one contains existing content, stop here rather than clearing it or pasting over it. Prepare a clean practice file before continuing. This guide does not supply a recovery or relocation procedure for an occupied destination.

Keep both blocks inside the same spreadsheet file. Google explicitly limits Paste special to a single spreadsheet and says that copying between spreadsheets in separate tabs does not provide that route. This walkthrough does not promise cross-file paste or a workaround for that restriction.

Use only the six text entries given above. Formatting, column widths, formulas and date representations are not being tested or promised. If your actual goal is separating parts of a text string, use the different split text to columns walkthrough. Here the input already consists of six separate cells.

Copy the block and choose Paste transposed

Select A1:C2 as a single rectangle. Check its upper-left and lower-right addresses before copying. Do not select the column headers, an extra blank row or the entire sheet. Copy the selected range, using Ctrl+C on Windows or Command+C on a Mac. Use Copy, not Cut, because the source must remain available for comparison.

In the same practice spreadsheet, select E1. That is the top-left cell of the intended output. Choose Edit, then Paste special, then Paste transposed. Google’s desktop instructions describe this option as pasting a rotated version of copied cells, with a column becoming a row and vice versa.

The English labels identify the intended function; they do not guarantee identical wording or layout in every interface language. Google also documents browser-related clipboard restrictions. If copying is blocked or the required menu option is unavailable, stop and write down the obstacle. Do not treat an ordinary paste as equivalent.

This guide does not ask you to install an extension, change permissions or alter account settings to overcome a missing control. It also does not introduce another spreadsheet as a fallback destination. An unavailable action is an honest incomplete exercise, not a reason to broaden the task without a clear plan.

Once the action is applied, inspect E1:F3. Expect a block that is three rows high and two columns wide. That shape is only the first check. The next section verifies the contents cell by cell and confirms that the original A1:C2 block still exists unchanged.

Verify the six destinations, not just the shape

The following map is the expected result derived from the fictional input. It is not a record of a signed-in Google session. Work through the map in order, comparing the displayed destination value with the stated source value. Every entry has a distinct address so that an incorrect selection can be identified precisely.

Start with the first destination row: E1 should read Code and F1 should read P1. The next row should contain Item at E2 and Notebook at F2. The last row should show Unit at E3 and each at F3. Finding the first pair correctly does not approve the remaining four cells.

Return to A1:C2 and compare the original values as well. There are two separate acceptance questions: did the output have the expected orientation, and did the source remain intact? A three-by-two block with the wrong value in F2 is not a fully checked result. Record the particular mismatch rather than simply writing failed.

This is not a test of future updates or a live relationship between the two blocks. Do not assume that later source changes will automatically update the pasted output. The named-range formula exercise handles another kind of spreadsheet task. No formula or calculated total is part of this walkthrough.

Save an honest record and check reopening separately

Finish with a small text record that identifies the file, ranges and six comparisons. Keep the expected values alongside your actual inspection status. The template below deliberately starts with unchecked fields. Replace them only after performing the corresponding checks in your own file, and name any mismatch by its cell address.

Practice file: ___
Source: A1:C2, text only
Destination: E1:F3, expected 3 rows × 2 columns
A1→E1 Code: unchecked; B1→E2 Item: unchecked
C1→E3 Unit: unchecked; A2→F1 P1: unchecked
B2→F2 Notebook: unchecked; C2→F3 each: unchecked
Source unchanged: unchecked
Spreadsheet reopened and inspected: not performed
Obstacle and next action: ___

You can keep this record in a local plain-text file. On Windows, open Start, launch Notepad and create a new document. On Mac, open TextEdit, choose File → New, then Format → Make Plain Text. Choose File → Save As on Windows or File → Save on Mac. Save in Documents as sheets-orientation-check.txt, choosing another name if it already exists. Close the note and reopen it from that folder, then read the six checks to confirm that your written record remains available.

The local note and the spreadsheet are different artifacts. Reopening the note does not verify the saved spreadsheet. Reopen the practice spreadsheet from the place you recorded earlier, then compare E1:F3 with the mapping again. If you have not done this, leave the spreadsheet-reopening field explicitly incomplete.

A fifteen-minute practice session aims for a checked small layout and a usable record, not a measured speed claim. If the action is blocked or the comparisons are incomplete, preserve the concrete next step. A truthful note about the missing menu or an occupied destination is more useful than an unsupported success label.

Choose a different guide for a different spreadsheet job

Transposing changes orientation. Sorting changes the order of records according to a chosen rule. If you need to arrange records by two fields, follow the separate two-column sort guide. Do not reinterpret this small orientation exercise as a sorting procedure.

The COUNTIF status-count walkthrough checks how many records match a status. Inspecting the six destinations here is not a business metric or a count formula. Pivot summaries, imports and larger cleanup workflows also remain outside the exercise.