Forum Discussion
Pivot
I have a table it has a key field that has duplicate numbers which I need to piviot each key field into 1 row. I have tried pivot and unpivot but nothing is seeming to work, can you assist? ...
Hi audi357
You may use 'Merge Queries' in query editor to get the table. Update the sample file for your reference. Please let me know if it helps you.
Regards,
Cherie
This solution does work! However I have a small issues I have multiple "NC_SEQ" it can be up to 50 (1-50), This solution accounts for up to two (1-2) "NC_SEQ". Is there and easy adjustment for this query?