+ Reply to Thread
Results 1 to 4 of 4

copy 4 rows of data with blanks to 1 row

  1. #1
    Registered User
    Join Date
    02-13-2014
    Location
    Dallas, Texas
    MS-Off Ver
    MS OFFICE 365
    Posts
    14

    copy 4 rows of data with blanks to 1 row

    Trying to copy 4 rows of data to 1 single row - but keep the same order.

    Attachment 624643

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,911

    Re: copy 4 rows of data with blanks to 1 row

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    02-13-2014
    Location
    Dallas, Texas
    MS-Off Ver
    MS OFFICE 365
    Posts
    14

    Re: copy 4 rows of data with blanks to 1 row

    Here is the simple File
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,522

    Re: copy 4 rows of data with blanks to 1 row

    Paste the following into cell A10 and drag across to cell N10:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Copy rows from multiple worksheets but do not include blanks
    By tillyman in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-07-2015, 02:18 AM
  2. Copy rows from multiple worksheets but do not include blanks
    By tillyman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-07-2015, 02:17 AM
  3. [SOLVED] Insert and Delete blanks rows so that there are 2 blanks rows between text rows
    By erniedawg in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-29-2013, 02:27 AM
  4. [SOLVED] Copy data from one sheet to another while skipping blanks and certain rows
    By gawk1980 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-15-2013, 07:34 AM
  5. [SOLVED] Copy data from one sheet to another while skipping blanks and certain rows
    By gawk1980 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-14-2013, 01:21 PM
  6. Copy Rows - Paste and remove blanks
    By tigerdel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-24-2012, 01:28 PM
  7. [SOLVED] Copy nth row but ignore blanks and incomplete rows
    By agentone in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-21-2012, 07:13 AM

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