Hi Guys,
Hope all well. Bit of a tricky one today - I have 13 columns (A:M) where A corresponds to a unique ID and Columns B:M correspond to monthly values. ExcelForum 1.PNG
I'm trying to create a formula that will go through each value in Column A and publish them in a column "O" and then next to them publish in order all of the values in Columns B:M. So essentially, the first value in column A will appear in 12 different rows and next to it the values in columns B:M. Then the formula will jump to the second value in column A, pull all the associated values in Columns B:M and then continue looping through this process.
ExcelForum 2.PNG
I know its some combination of index, match with a small but its been a while and I've forgotten how to do this. I have attached an excel which should clarify any questions.
Thanks SO MUCH!
Larry
Bookmarks