How to move values in a list with common fileds

Question

I want to convert:

From a list of columns that has a common label, to a row where labels are not repeated and all the values are listed under them. Is there a way to do it ?

Answer 1

Assuming

• data is in columns A:B

• results to start in E9

• Your version of Excel has UNIQUE and FILTER functions

  E9:  =TRANSPOSE(UNIQUE(FILTER($A:$A,$A:$A<>"")))
  E10: =FILTER($B:$B,$A:$A=E$9)
  

Select E10 and fill right as far as needed

If you don't have those functions, I would suggest Power Query or VBA to perform the data transformation.