+ Reply to Thread
Results 1 to 6 of 6

One large column of data - convert it to rows?

  1. #1
    Registered User
    Join Date
    04-23-2013
    Location
    MA
    MS-Off Ver
    Excel 2010
    Posts
    2

    One large column of data - convert it to rows?

    Hello,

    I have a large column of data (pasted from a website) which I would like to see broken into rows. the data presents as:

    change #
    (random empty spaces)
    title of change
    (random empty spaces)
    Testing notes
    (random empty spaces)

    change #
    (random empty spaces)
    title of change
    (random empty spaces)
    Testing notes
    (random empty spaces)

    change #
    (random empty spaces)
    title of change
    (random empty spaces)
    Testing notes
    (random empty spaces)

    change #
    (random empty spaces)
    title of change
    (random empty spaces)
    Testing notes
    (random empty spaces)


    and so on and so on -

    I would like it to display as follows:

    change # title of change Testing notes
    change # title of change Testing notes
    change # title of change Testing notes
    change # title of change Testing notes
    change # title of change Testing notes
    change # title of change Testing notes
    change # title of change Testing notes



    All data pasted into Column A.

    Anyone have a macro to help? i've searched a few other posts, and found similar problems, but those macros fail on me. I'm VERY novice at macros, so any instructions would be super helpful.

    Thank you in advance.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,038

    Re: One large column of data - convert it to rows?

    So the change # occurs EVERY 7 rows WITHOUT FAIL?
    Last edited by Special-K; 04-23-2013 at 12:33 PM.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    04-23-2013
    Location
    MA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: One large column of data - convert it to rows?

    Hi,
    No unfortunately, there are random amounts of blank/empty cells inbetween each of the of items.

    there is text in the change # field that is consistent, without fail : "C/S CM Request #" this would be the start of a new row.

  4. #4
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,038

    Re: One large column of data - convert it to rows?

    This works

    Please Login or Register  to view this content.

  5. #5
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,038

    Re: One large column of data - convert it to rows?

    Mm, then that wont work, it assumes the change # will be every 7 rows after line 1

  6. #6
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2010
    Posts
    6,516

    Re: One large column of data - convert it to rows?

    Pl see the attached file with macro.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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