+ Reply to Thread
Results 1 to 3 of 3

Macro required to paste rows onto a single row until value changes in a column: HELP!!

  1. #1
    Registered User
    Join Date
    01-12-2014
    Location
    Sydney
    MS-Off Ver
    Excel 2003
    Posts
    4

    Macro required to paste rows onto a single row until value changes in a column: HELP!!

    Hello all,

    Sorry about the ambiguous description but I'm not exactly sure how to best describe it. Best to look at the example attached.

    I have a data dump with 400K rows. I need a macro to go down column B, and whilst the Acc_ID is the same, I need to paste the values in column B,C and D onto the same row as the first occurrence of the value in column B. Basically, I want to transpose the data into the first available blank column as long as my Acc_ID column has not changed. Once it changes, then that will be the next row that has values get copied on to as the macro goes down each row.

    i would really appreciate any help at all. I'm ny good at writing macros at all and because the data is 400k rows long, I would really love to have a macro to do it for me.

    Thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    09-26-2014
    Location
    Moscow, Russia
    MS-Off Ver
    MSE 10, MSE 13
    Posts
    179

    Re: Macro required to paste rows onto a single row until value changes in a column: HELP!!

    Good time of day!

    Allow me to present a humble solution. Test button is in the attachment. When job is done - a message will appear.

    For proper use, please, be sure that column B is sorted and that you data (A, 0.7, 44 and so on) starts from cell B4

    What do you think?

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Best wishes and have a nice day!

  3. #3
    Registered User
    Join Date
    01-12-2014
    Location
    Sydney
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Macro required to paste rows onto a single row until value changes in a column: HELP!!

    YOU ARE DA MAN! Thanks very much for taking the time to work this through. It's much appreciated! You have a good day...

+ 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. Macro to copy and paste a single column into several different columns
    By Matt2014 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2014, 08:37 AM
  2. [SOLVED] macro to find same largest values in a column and delete all other rows..help required!!
    By gokzee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2012, 11:34 PM
  3. Macro Required - Hide columns where cell in a single column is empty
    By heatwave in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2012, 12:53 AM
  4. Cut Mulitple Rows & paste single Column
    By Musthafa1977 in forum Excel General
    Replies: 6
    Last Post: 04-19-2011, 12:21 PM
  5. How to insert required number of rows instead of a single row
    By TRJJK73 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2008, 11:04 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