Results 1 to 18 of 18

Concatenate, Delete Blank Rows & Remove Repeated Header

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-12-2012
    Location
    Jeddah, Saudi Arabia
    MS-Off Ver
    2010, 2013, 2016, Office 365
    Posts
    521

    Concatenate, Delete Blank Rows & Remove Repeated Header

    Hi,

    I have have worksheet on which data is pasted on daily basis. There are some data which appears on two cell. What I need

    Concatenate those cells which in two rows (Column E, F & M)
    Delete all the blank rows
    Delete repeated Header Rows (Except Row One)

    Al these process should be done on sheet Expected Result (Keeping the Original Data as it is)
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Delete Unnecessary Data and Remove Blank Rows
    By kingsdime29x in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-10-2017, 02:26 AM
  2. [SOLVED] Concatenate If Blank - remove blank line if first cell is blank
    By ker9 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-27-2014, 02:14 PM
  3. [SOLVED] Delete the Rows If it is Blank cell below Table header "Status"
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-19-2012, 05:55 AM
  4. how to remove the blank column (delete rows)
    By SelinaT in forum Excel General
    Replies: 1
    Last Post: 04-18-2011, 03:50 AM
  5. Remove repeated rows.
    By Hugo555 in forum Excel General
    Replies: 1
    Last Post: 05-07-2009, 03:09 AM
  6. Macro to remove the blank rows and detect header
    By coolanks1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-20-2009, 03:40 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