+ Reply to Thread
Results 1 to 6 of 6

Shift all columns left/ Delete all empty columns between filled columns

  1. #1
    Registered User
    Join Date
    10-02-2017
    Location
    Washington, DC
    MS-Off Ver
    MS Office 2011
    Posts
    3

    Shift all columns left/ Delete all empty columns between filled columns

    Hi guys,

    I have to convert a ton of tables in pdf format to excel for work. The problem is they often come out as a bunch of merged cells and when I unmerge them I am left with a bunch of empty columns between the ones I care about. Is there anyway to shift all columns all the way to the left so that they are next to each other and without blank columns in between? I have tried to attach an image of what my sheets look like (not sure if it worked).

    Thanks for the help
    Screen Shot 2017-10-04 at 11.04.06.png

  2. #2
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: Shift all columns left/ Delete all empty columns between filled columns

    Try this tested & working macro I found @ ExtendedOffice.com
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-02-2017
    Location
    Washington, DC
    MS-Off Ver
    MS Office 2011
    Posts
    3

    Re: Shift all columns left/ Delete all empty columns between filled columns

    Great thanks for the help. the only issue is that the data is scattered across different columns

  4. #4
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: Shift all columns left/ Delete all empty columns between filled columns

    Quote Originally Posted by cslarson33 View Post
    the only issue is that the data is scattered across different columns
    Did you try the code?
    In my test, I had the columns similar to your posted image, and it work well.

  5. #5
    Registered User
    Join Date
    10-02-2017
    Location
    Washington, DC
    MS-Off Ver
    MS Office 2011
    Posts
    3

    Re: Shift all columns left/ Delete all empty columns between filled columns

    Yes I did try the code. I also didnt have headers in the data so it didnt do much. I found a different way though. I was able to select all the affected columns and then us fn F5 (for mac) to pull up the go to window. Then I used special> blanks and it selected all blank spots in my sheet. Then simply delete and shift left

  6. #6
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: Shift all columns left/ Delete all empty columns between filled columns

    Deleted by Me
    Last edited by Syrkrasi; 10-06-2017 at 04:02 PM. Reason: I'm assuming that the OP solved his/her issue

+ 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] Copying Columns and rows from one sheet to another EXCEPT color filled and empty
    By Tgun in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-12-2017, 10:22 AM
  2. [SOLVED] Delete a set of Columns with 2 empty columns
    By sarajun_88 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-04-2017, 10:56 PM
  3. [SOLVED] Delete Duplicate Cells - Shift Columns left
    By Tellm in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-12-2015, 03:20 PM
  4. Delete empty cells, and shift left
    By kiboodez in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 07-25-2014, 07:53 AM
  5. Delete Range of Rows and Columns and Shift Up
    By BobBing in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-17-2012, 02:02 PM
  6. [SOLVED] How to select all records in a empty column between to filled columns
    By boerbende in forum Excel General
    Replies: 3
    Last Post: 11-20-2011, 07:37 AM
  7. Delete empty cells and shift remaining left
    By kiboodez in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2010, 02:17 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