+ Reply to Thread
Results 1 to 4 of 4

rearranging column data with repeat instances and blank cells

  1. #1
    Registered User
    Join Date
    09-08-2016
    Location
    Los Angeles, CA
    MS-Off Ver
    Office 365
    Posts
    22

    rearranging column data with repeat instances and blank cells

    Hello wise benefactor! Thank you for lending a hand. I do hope this is the right place for this question.

    I have data to rearrange and output to two sheets. Data is in worksheet "raw" and output sheets are "output_1" and "output_2", respectively on attached.
    First, data columns 1 to 9 are characteristics of retailers, of which I've manually selected 94 unique and copied to output_1. I want to rearrange the the grades and dates in Columns 10 and 11 to output_1. Not every date has a grade, and each retailer does not exhibit the same dates. Because "raw" columns have duplicates, I have not been able to fill in the other gaps on "output_1". I hope the layout shows more clearly what I'm trying to do.
    Secondly, in output_2, I want to arrange the grade change dates and corresponding grades for each unique retailer. Can VBA do that?
    Open to all ideas. Thank you again.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    12-14-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    295

    Re: rearranging column data with repeat instances and blank cells

    Try this
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Note: Output_2 is rearranged from data of output_1. So, allway run output_1 before run output_2.

  3. #3
    Registered User
    Join Date
    09-08-2016
    Location
    Los Angeles, CA
    MS-Off Ver
    Office 365
    Posts
    22

    Re: rearranging column data with repeat instances and blank cells

    Thank you so much huuthang_bd! Figuring out how you did it, and some NOOB errors on my part, prolonged this thank you message. Your solution has breathed new life into my work!

  4. #4
    Forum Contributor
    Join Date
    12-14-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    295

    Re: rearranging column data with repeat instances and blank cells

    Thank you for reply. Please mark this thread as SOLVED if your problem was solved.

+ 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