Pivot

Question

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?

v-cherch-msft · Answer

Hi&nbsp;audi357&nbsp;You may use 'Merge Queries' in query editor to get the table.&nbsp;Update&nbsp;the sample file for your reference. Please let me know if it helps you.&nbsp;Regards,Cherie

audi357 · Answer

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?

v-cherch-msft · Answer

Hi&nbsp;audi357&nbsp;Add some rows and steps for sample data. You may check if it matches your request. Here is the sample file.&nbsp;Regards,Cherie

audi357 · Answer

The first sample only 1&nbsp; unique "key" which&nbsp;is correct.&nbsp; This sample would not give the desired results. &nbsp;&nbsp;In the first sample I added multiple steps&nbsp; "Merge3 (nc_seq = 3), merge4 (nc_seq=4), merge5 (nc_seq=5)" then Merged them all together adding one at a time.&nbsp; This does work.&nbsp; However I will need to create a total of 50 steps.&nbsp; Is there a better solution? &nbsp;

v-cherch-msft · Answer

Hi&nbsp;audi357&nbsp;I'm afraid i cannot reproduce your scenario. Maybe you need change the filter rows with other conditon such as 'dose not equal'.&nbsp;Regards,Cherie&nbsp;&nbsp;

Forum Discussion

Pivot

6 Replies

Related content

Pivot issue

Pivot / Unpivot?

Pivot(?) Help

Pivot\Unpivot

Table Pivot, result explanation