+ Reply to Thread
Results 1 to 7 of 7

Format 1 row in excel to many rows incrementally by range in row until blank cell

  1. 05-26-2017, 04:19 PM #1
    jmoore3535
    jmoore3535 is offline
    Registered User
    Join Date
    05-26-2017
    Location
    Detroit, MI
    MS-Off Ver
    2010
    Posts
    3

    Format 1 row in excel to many rows incrementally by range in row until blank cell

    I would Like to format the following with an excel macro from Sheet1 (input) to sheet 2 (output)

    Sheet 1
    Capture.PNG

    Sheet 2 - Output from Sheet 1 Macro
    Capture1.PNG
    Reply With QuoteRegister To Reply
  2. 05-26-2017, 06:27 PM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,699

    Re: Format 1 row in excel to many rows incrementally by range in row until blank cell

    Here is a Normalization Macro I developed awhile ago. It should get you on the right path and you may have to modify it to meet your specific needs as this was developed with only one static column (column A).

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  3. 05-27-2017, 02:45 AM #3
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,957

    Re: Format 1 row in excel to many rows incrementally by range in row until blank cell

    Hi jmoore3535

    Welcome to the forum. Can give this a go...
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  4. 05-27-2017, 03:06 AM #4
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Format 1 row in excel to many rows incrementally by range in row until blank cell 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 05-30-2017, 09:32 AM #5
    jmoore3535
    jmoore3535 is offline
    Registered User
    Join Date
    05-26-2017
    Location
    Detroit, MI
    MS-Off Ver
    2010
    Posts
    3

    Re: Format 1 row in excel to many rows incrementally by range in row until blank cell

    Thank you all for your replies, I am just getting back from the long weekend and I will give your suggestions a try here in a bit! Thank you so much, I will post back with results.
    Reply With QuoteRegister To Reply
  6. 05-30-2017, 03:14 PM #6
    jmoore3535
    jmoore3535 is offline
    Registered User
    Join Date
    05-26-2017
    Location
    Detroit, MI
    MS-Off Ver
    2010
    Posts
    3

    Re: Format 1 row in excel to many rows incrementally by range in row until blank cell

    Thank you!! This worked perfectly!

    Both sintek and jindon's solution worked

    Thanks so much!
    Reply With QuoteRegister To Reply
  7. 05-31-2017, 05:02 AM #7
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,957

    Re: Format 1 row in excel to many rows incrementally by range in row until blank cell

    Pleasure...Thanks for rep points
    Please mark thread as solved...
    Last edited by Sintek; 05-31-2017 at 05:04 AM.
    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. Loop through rows in an excel worksheet and copy a range if the last cell isn't blank
    By JWHeel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2017, 05:22 PM
  2. Copying COUNTIF across Columns but range changing incrementally
    By Staniel1975 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-02-2016, 10:54 PM
  3. Macro to hide range of 13 rows if sutotal of range for row 1-13=0 (includes 2 blank rows)
    By jcskwells in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-24-2013, 05:44 AM
  4. Mac Excel: Hiding rows if cell blank, when being blank depends on a conditional formula
    By lee_5_5 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 06-06-2013, 11:25 PM
  5. [SOLVED] How do I format cell when date is 10 days from expiring, AND other rows are blank
    By auslegung in forum Excel General
    Replies: 2
    Last Post: 02-07-2013, 04:50 PM
  6. Format or List Every nth Non-Blank Cell in a Range
    By oxv in forum Excel General
    Replies: 2
    Last Post: 09-20-2012, 11:30 AM
  7. Delete a range of rows above blank cell
    By d_rock90 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-07-2008, 10:45 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1