Need to change the transpose the data of base

[sunilkumar1988]

How to change the below data in transpose form

Input Data :

Parent Biz Unit	Codes
BLG01M78	2234
BLG01M78	1245
BLG01M78	8765
BLG01M78	8724
BLG01M78	7890
BLLG01SFL	5678
BLLG01SFL	2345
BLLG01SFL	9877
BLLG01SFL	5299
BLLG01SFL	9477

Accepted output data :

Parent Biz Unit	Code 1	Code 2	Code 3	Code 4	Code 5
BLG01M78	2234	1245	8765	8724	7890
BLLG01SFL	5678	2345	9877	5299	9477

[#2]

@sunilkumar1988 

Similar question already asked n times on this forum where there's a Search functionnality...

With Power Query (corresponding sample attached):

[#3]

Was answered with the unique formula in this post. Transpose is not what I was looking for Thanks