In a spreadsheet I have employee names in Column A and corresponding data in Column B. I need to find the data in Column B that matches the employee names and move that data up to a single row per employee.
I tried an array formula
=ADDRESS(3,MAX((3:3<>"")*COLUMN(3:3)),1)
and the MATCH function
=MATCH(TRUE,INDEX(ISBLANK(B1:B3000),0,0),0)
But, couldn't find a combination that would return the values (and put them in the next blank cell on the corresponding row)
Is this something that can only be solved with VBA?
I tried an array formula
=ADDRESS(3,MAX((3:3<>"")*COLUMN(3:3)),1)
and the MATCH function
=MATCH(TRUE,INDEX(ISBLANK(B1:B3000),0,0),0)
But, couldn't find a combination that would return the values (and put them in the next blank cell on the corresponding row)
Is this something that can only be solved with VBA?