+ Reply to Thread
Results 1 to 2 of 2

move certain rows right one column at specified place

  1. #1
    Registered User
    Join Date
    02-08-2019
    Location
    Boston, MA USA
    MS-Off Ver
    2016 Excel; 2007 Excel
    Posts
    1

    move certain rows right one column at specified place

    I have a worksheet that has 10 columns of data, and 2000 rows. For some of the rows, there was no entry for the fifth column so that column 5 now has the data meant for column 6 and column 6 has the data for column 7, etc.. In other words, beginning with column 5 everything in the row has shifted to the left by one column. This only occurs in some of the 2000 rows. It can easily be detected because the data in column 6 always begins with a 'D', so when that occurs in column 5 it shows that need to shift all the columns of that row beyond the fourth column to the right by one column and have column 5 be an empty cell for that row.

    I can manually sort so all the affected columns are on top, and then select and manually insert in order to shift one column, but we will likely be getting data similar to this in the future and a VBA script that would automatically fix this would be ideal.
    Attached Files Attached Files
    Last edited by maexel; 02-08-2019 at 04:58 PM. Reason: attach example excel worksheet

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,822

    Re: move certain rows right one column at specified place

    Could you attach a copy of your file so we can visualize how your data is organized? De-sensitize the data if necessary.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

+ 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. Format column to move the decimal place of the entries
    By Keats713 in forum Excel General
    Replies: 5
    Last Post: 12-28-2016, 01:39 PM
  2. Replies: 12
    Last Post: 03-14-2016, 08:42 AM
  3. Remove duplicate rows and move the column data to a new column
    By cmray58 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-22-2015, 03:46 PM
  4. [SOLVED] Move the result to next column B available row if column A rows is not empty
    By Malou in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 03-29-2015, 11:02 AM
  5. Take rows of text and move to into a new column, each column easily identified
    By CATTX01 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2015, 03:35 PM
  6. Replies: 4
    Last Post: 01-18-2014, 03:24 AM
  7. HELP: Move values from column to rows based on Column A
    By ExceJunkie in forum Excel General
    Replies: 2
    Last Post: 05-30-2013, 08:09 AM

Tags for this Thread

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