+ Reply to Thread
Results 1 to 8 of 8

Move 100 Columns into 1 column

  1. 05-14-2015, 10:51 AM #1
    AstToTheRegionalMGR
    AstToTheRegionalMGR is offline
    Forum Contributor
    Join Date
    11-12-2014
    Location
    Boston, MA
    MS-Off Ver
    Office 2010
    Posts
    172

    Move 100 Columns into 1 column

    Hi,

    I have 100 columns' worth of data, each with the same number of rows. Range is E2:CZ202. I need to move all these columns into one column in Column A. Anyone have a useful macro?

    thanks!
    Reply With QuoteRegister To Reply
  2. 05-14-2015, 10:58 AM #2
    Arkadi
    Arkadi is offline
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Move 100 Columns into 1 column

    How about:

    Please Login or Register  to view this content.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.
    Reply With QuoteRegister To Reply
  3. 05-14-2015, 10:58 AM #3
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Move 100 Columns into 1 column

    Something like this:

    Please Login or Register  to view this content.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
  4. 05-14-2015, 11:01 AM #4
    AstToTheRegionalMGR
    AstToTheRegionalMGR is offline
    Forum Contributor
    Join Date
    11-12-2014
    Location
    Boston, MA
    MS-Off Ver
    Office 2010
    Posts
    172

    Re: Move 100 Columns into 1 column

    Quote Originally Posted by Arkadi View Post
    How about:

    Please Login or Register  to view this content.
    Arkadi: This only moved Column E
    Reply With QuoteRegister To Reply
  5. 05-14-2015, 11:03 AM #5
    Arkadi
    Arkadi is offline
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Move 100 Columns into 1 column

    I think I totally misunderstood the request... i was merging all the values across into one column for the given row's data.
    Reply With QuoteRegister To Reply
  6. 05-14-2015, 11:03 AM #6
    AstToTheRegionalMGR
    AstToTheRegionalMGR is offline
    Forum Contributor
    Join Date
    11-12-2014
    Location
    Boston, MA
    MS-Off Ver
    Office 2010
    Posts
    172

    Re: Move 100 Columns into 1 column

    JBeaucaire:

    You the best! It worked!
    Reply With QuoteRegister To Reply
  7. 05-14-2015, 11:04 AM #7
    Arkadi
    Arkadi is offline
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Move 100 Columns into 1 column

    Actually, didn't move just e.... simply merged the entire row into one cell in column A, misunderstood what you wanted.
    Reply With QuoteRegister To Reply
  8. 05-14-2015, 11:06 AM #8
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Move 100 Columns into 1 column

    Quote Originally Posted by AstToTheRegionalMGR View Post
    JBeaucaire:

    You the best! It worked!
    Glad to help.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Convert column B as multiple column titles and move data in column C into new columns?
    By princesscathryn in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 06-30-2014, 07:31 PM
  2. Move cell from column A to directly to column G - skip BCDE columns
    By vengatvj in forum Excel General
    Replies: 4
    Last Post: 09-23-2013, 06:19 PM
  3. [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
  4. How can I move columns 1, 2, 3, 4 to all be in column 1
    By iiiitara in forum Excel General
    Replies: 8
    Last Post: 01-16-2009, 06:41 PM
  5. 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1