Values in new columns

Question

HelloI have table with:&nbsp;1. RMA number (unique)2. SN (not unique)3. Date open (date)4. Date closed (date)I want to create table, with rows for every RMA and SN like so:Input table:RMA&nbsp; &nbsp; &nbsp; SN&nbsp; &nbsp; Date Open&nbsp; &nbsp;Date ClosedR1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;123&nbsp; &nbsp;&nbsp;R2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;234R3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;123R4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;123R5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;234R6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;433&nbsp;Result table:SN&nbsp; &nbsp; &nbsp; &nbsp; RMA1&nbsp; &nbsp;Date open 1&nbsp; &nbsp; &nbsp; &nbsp;Date close 1&nbsp; &nbsp; &nbsp;RMA2&nbsp; &nbsp; Date Open 2&nbsp; &nbsp; &nbsp;Date close 2&nbsp; &nbsp;RMA 3&nbsp; &nbsp;Date Open 3&nbsp; &nbsp; Date open 4&nbsp; &nbsp;...123&nbsp; &nbsp; &nbsp; &nbsp;R1&nbsp; &nbsp; &nbsp; &nbsp; (date)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(date)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; R3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(date)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(date)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;R4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (date)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(date)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;...&nbsp;&nbsp;234&nbsp; &nbsp; &nbsp; &nbsp;R2&nbsp; &nbsp; &nbsp; &nbsp; (date)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(date)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; R5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(date)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(date)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;blank&gt; &lt;blank&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;blank&gt;433&nbsp; &nbsp; &nbsp; &nbsp;R6&nbsp; &nbsp; &nbsp; &nbsp; (date)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(date)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;blank&gt;&nbsp; &nbsp; &lt;blank&gt; ...Can you give mi hint how to do thisI tried Lookupvalue, but it's not suited for multiplre results and to pivot table

v-eachen-msft · Accepted Answer

Hi&nbsp;Telkontar&nbsp;,
&nbsp;
You can&nbsp;split the table based on SN and merge them in the query editor.
&nbsp;

Forum Discussion

Values in new columns

1 Reply

Related content

Splitting Column values

Matching Column Values

Check column for similar values

Total value missing in calculated column

Retrieving Values from Single Column