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.
Bookmarks