+ Reply to Thread
Results 1 to 2 of 2

Formula for taking Info from same row dif Columns to make a list

  1. #1
    Registered User
    Join Date
    09-26-2012
    Location
    el paso, texas
    MS-Off Ver
    Excel 2003
    Posts
    5

    Formula for taking Info from same row dif Columns to make a list

    Need some help. Hope I can explain it well enough. I am attaching the work sheet to make it easier to understand. I need to take info from the same row, yet different columns, and turn it into a verticle list on another part of the same workbook. in my example that I attach, the yellow highlighted part of the row is what I am turning into a list. The "components" section of my lunch menu builder workbook and turn the components into a verticle list. I hope I didnt confuse anyone. Sample for excell forum menu builder.xlsx I need to take all the info from E4:X4 and put it into a list on AC4:AC23. Thats all I need the Formula to do. and then be able to copy that formula to the other "components" list so that E5:X5 goes to AH4:AH23, and info in E6:X6 goes to AM4:AM23.....etc If anyone can help with this it will be a great help, thanks.

  2. #2
    Registered User
    Join Date
    09-26-2012
    Location
    el paso, texas
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Formula for taking Info from same row dif Columns to make a list

    Thanks for the help. It really does work now and a big headache has been lifted.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1