Forum Discussion
Need to change the transpose the data of base
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 Replies
- Was answered with the unique formula in this post. Transpose is not what I was looking for Thanks
Similar question already asked n times on this forum where there's a Search functionnality...
With Power Query (corresponding sample attached):
