Hi,
i am looking for help to convert from the below table to a new format
| Part Name | Component | 
| A | 1 | 
| A | 2 | 
| A | 3 | 
| A | 4 | 
| A | 5 | 
| B | 2 | 
| B | 6 | 
convert to
| Part | Component 1 | Component 2 | Component 3 | Component 4 | Component 5 | Component 6 | Component 7 | 
| A | 1 | 2 | 3 | 4 | 5 | ||
| B | 2 | 6 | 
anyone has a quick solution?
thank you
Solved! Go to Solution.
Hi Tim, yes this is perfect, I have not used the Tile Feature yet, this is great.
Thank you
Allen
