+ 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 (Isle of Sodor)
    MS-Off Ver
    MS Excel 2019
    Posts
    22

    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
    722

    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


    If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !

+ 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