I have these two columns in Excel. Group Numbers in col A and Value (some relevant numeric data) in next column B.
I need to extract only the rows for Group 1 into a separate columns or a table as shown in the picture. I want to avoid Filters & Copy-Paste because the values may change over time.
I am using INDEX function with a helper column to achieve this. However is there a better solution without the Helper Column with a direct working formula? I am using Excel 2013 Any help is much appreciated.
Thanks in advance.