Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
67
Views
Topic starter
Hi,
I got a table like below:
| Part No. | Description |
| 1800 | Part A |
| 1801 | Part B |
| 1802 | Part C |
| 1803 | Part D |
| 2000 | Part E1 |
| 2000 | Part E2 |
| 2000 | Part E3 |
| 2000 | Part E4 |
| 2000 | Part E5 |
| 2000 | Part E6 |
| 2000 | Part E7 |
| 2001 | Part F |
| 2002 | Part G |
| 2003 | Part H |
How to transform above table like below using power query? This is a sample table and list is quite big.
| Part No. | 1800 | 1801 | 1802 | 1803 | 2000 | 2001 | 2002 | 2003 |
| Description | Part A | Part B | Part C | Part D | Part E1 | Part F | Part G | Part H |
| Part E2 | ||||||||
| Part E3 | ||||||||
| Part E4 | ||||||||
| Part E5 | ||||||||
| Part E6 | ||||||||
| Part E7 |
Please help!!!
Kind Regards
Arun
Posted : 30/06/2018 5:06 am
Hi Arun,
Add an index column to your data. Then Pivot the Part no. column and choose the Description column as the 'Values' and in 'Advanced Options' choose 'Don't aggregate'.
You will get the results staggered over the rows, but this is as best as you can do.
Mynda
Posted : 30/06/2018 11:06 pm
