+ Reply to Thread
Results 1 to 2 of 2

Cutting and pasting from 1 column to another

  1. #1
    Registered User
    Join Date
    11-27-2022
    Location
    earth
    MS-Off Ver
    Libre Calc (Linux) Saving as Excel 2007-2019 (xlsx)
    Posts
    6

    Cutting and pasting from 1 column to another

    All:
    (see attached worksheet)
    Windows 10 Excel 2019
    I have 2 columns of data in my worksheet.
    I need to move column D info to one-off rows in column A
    Example: D1 should be moved to A2. D5 should be moved to A6 and so on.
    There are thousands of rows, so I can?t just move the entire column, because it would overwrite the data in rows 3,4,7,8,11,12,19,20 of column A, etc.
    Is there a way to do this in an automated way without ctrl-clicking on each cell in column D? (there are 1000?s of them)
    Thanks in advance
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    544

    Re: Cutting and pasting from 1 column to another

    Hi,
    With helper column: E
    In E1
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    In E2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and drag down
    Attached Files Attached Files
    Diana Tanase

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Cutting and pasting numbers only to adjacent column/Subtotalling
    By pauldaddyadams in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-17-2014, 09:54 AM
  2. Cutting and pasting between worksheets based on a column
    By mmcgrail in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-09-2014, 07:16 AM
  3. Cutting and Pasting rows loopwise as per the same value in Proposal(Column E)
    By mvneema in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2014, 04:40 PM
  4. Replies: 1
    Last Post: 11-22-2011, 06:28 PM
  5. Cutting and Pasting numbers in a column
    By ben5496 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2011, 05:15 PM
  6. Replies: 7
    Last Post: 07-09-2010, 09:57 AM
  7. cutting a row and pasting to a column
    By wolfdogg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-23-2005, 05:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1