Convert each name and corresponding data into separate columns

I have this data in google sheets and the name can be more or less based on the data I want to convert it into separate column.

This will be the last result.

Your help will be much appreciated.

I tried using the 4 filter function but its result was not dynamic first I define the name then filter function come with result.

Using Filter Dynamically and Stack it

Your Filter approach is correct, dynamically running through it you use iterators of Google Sheets like Reduce like what I have used. Add a Choosecols to remove the additional array added on by the Reduce function. Sequence is just for generating the number of columns that was supposed to be in the array.

Try this approach

=CHOOSECOLS(REDUCE(,UNIQUE(A2:A), LAMBDA(a,c, IFNA(HSTACK(a,FILTER(A2:B, A2:A = c)),""))), SEQUENCE(1, COUNTA(UNIQUE(A2:A))*2, 2, 1))

Result:

Reference:

Reduce Function