Results 1 to 19 of 19

Move data from Column A-E or B-F to columns G-K

Threaded View

  1. #1
    Registered User
    Join Date
    09-19-2013
    Location
    DC
    MS-Off Ver
    Excel 2010
    Posts
    11

    Move data from Column A-E or B-F to columns G-K

    HI,
    I want to move couple of data from columns A-E or B-F to G-K. How do I do this. I have 27000 records in the excel and the requirement is : See the sample excel attached. In the attached excel the correct format for sub rows is Row 3. I need to move Row 5-13 to Columns G-K,Row 15 to columns G-K,Row 17-22 to columns G-K and so on. The row with the number which is 10digits will not move.(Like Row 1,4,14,16). Is there any macro for this type of issues or what is the best way to deal as I have 27000 reocords similarly. Good thing is I have constant columns.

    Thanks
    NewBie
    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. [SOLVED] How to move one Column's data to other Columns...
    By LeoThe Lion in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-25-2012, 05:11 AM
  2. Help needed about move one Column data to other Columns...
    By LeoThe Lion in forum Excel General
    Replies: 1
    Last Post: 06-25-2012, 03:22 AM
  3. Move data to new columns when cell in Column A is blank
    By MrClaw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2010, 12:51 PM
  4. [SOLVED] How do i move data series into other columns on column charts
    By JamesO in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-03-2006, 12:50 PM
  5. [SOLVED] Move Data from one column to many columns
    By Barb in forum Excel General
    Replies: 3
    Last Post: 01-16-2006, 01:00 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