Need to change the transpose the data of base

New Contributor

How to change the below data in transpose form

 

Input Data :

 

Parent Biz UnitCodes
BLG01M782234
BLG01M781245
BLG01M788765
BLG01M788724
BLG01M787890
BLLG01SFL5678
BLLG01SFL2345
BLLG01SFL9877
BLLG01SFL5299
BLLG01SFL9477

 

Accepted output data :

 

Parent Biz UnitCode 1Code 2Code 3Code 4Code 5
BLG01M7822341245876587247890
BLLG01SFL56782345987752999477
2 Replies

@sunilkumar1988 

 

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

 

With Power Query (corresponding sample attached):

Sans titre.png

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