+ Reply to Thread
Results 1 to 3 of 3

Auto Filling from a Column to Rows, with Changes in Column Data

  1. #1
    Registered User
    Join Date
    05-01-2020
    Location
    america
    MS-Off Ver
    office 365
    Posts
    2

    Auto Filling from a Column to Rows, with Changes in Column Data

    Hello Everyone!

    Appreciate your help here. I have export data where in Column A is the Category, then in Column B is Item ID#, per category. Column A stays empty until the next category. What I want to do is add a dummy column that pastes the proper category into the row it belongs in, while linking to the the proper category group in column A. There is an uneven number of rows per category. This goes on for several thousand categories. Its a little hard to explain in text (because in a way its not "column data" as the title suggests, but row to row data) - a visual makes the problem clear:

    This is how the export comes out:
    Excel Category Help 1 - Copy.PNG

    This is how it should look. In this case I just did it manually, but ideally the solution to filling down column C is formulaic (that's where you guys come in )
    Excel Category Help 2 - Copy.PNG

    Attached is the sample worksheet.

    Thank you everyone for the help
    Attached Files Attached Files
    Last edited by AliGW; 05-18-2020 at 12:30 AM.

  2. #2
    Forum Expert Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    3,636

    Re: - Auto Filling from a Column to Rows, with Changes in Column Data

    Please try at C2

    =IF(B2="","",LOOKUP("zz",A$2:A2))
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    05-01-2020
    Location
    america
    MS-Off Ver
    office 365
    Posts
    2

    Re: Auto Filling from a Column to Rows, with Changes in Column Data

    worked like a charm! thank you Bo_Ry!! added a rep star, and bonus for me, learned something new - had never seen LOOKUP before. thanks again

+ 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. Help auto filling using column letters instead of numbers
    By T.ajt in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-31-2019, 11:39 PM
  2. Auto-adjust # of rows in a column that have a formula based on adjacent column data?
    By Norcal1 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 05-31-2018, 02:03 PM
  3. Auto Filling Column
    By tammyp3 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-29-2016, 04:23 PM
  4. Manually auto-filling a column by 3's
    By radius1080 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2015, 09:40 AM
  5. Manually auto-filling a column by 3's.
    By radius1080 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-25-2015, 09:33 AM
  6. [SOLVED] Creating 'Region' column and auto filling data. Please help.
    By leepwbriggs in forum Excel General
    Replies: 4
    Last Post: 06-12-2015, 06:52 AM
  7. auto filling info into next column
    By richpngu in forum Excel General
    Replies: 2
    Last Post: 06-20-2014, 07:19 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