Generate row based on RecordID and then populate with data from seperate column.

[sam_mulholland]

I am relatively new to Alteryx so apologies if this is simple. I am trying to generate a row where there is a new RecordID and then populate the 'Quote' column with the output found in the 'Silver' column. I have tried a couple of methods and can't get the output to have the desired effect. 

Sample Data:

RecordID	Quote	Silver
100327	16.91	15.14
100327	22.09	15.14
100327	23.24	15.14
100328	29.9	16.98
100328	27.7	16.98
100328	14.42	16.98

Desired Output: 

RecordID	Quote
100327	16.91
100327	22.09
100327	23.24
100327	15.14
100328	29.9
100328	27.7
100328	14.42
100328	16.98

[alexnajm · Accepted solution]

Looks like a Summarize tool and a union tool will do the trick! Go from there to figure out the sorting - RecordID tools may help :)