Hi guys! There&#39;s a &quot;easy/fast&quot; way to rewrite a query from this:<div><br></div><div>Select datetime,key,value from table where ...</div><div><br></div><div>To this:</div><div><br></div><div>Select datetime, value1 as key1, value2 as key2, .... From table where ...</div><div><br></div><div>I don&#39;t remember the right name in R/python (pandas) language but it&#39;s something like vector/matrix merge</div><br><div>The ideia is, instead of one line of date key vale, use a single date, and &quot;put&quot; values as columns, and the columns name is the key name</div><div><br></div><div>The table structure is something like:</div><div>Create table (</div><div>Datetime datetime not null,</div><div>Key varchar(255) not null,</div><div>Value double not null,</div><div>Primary key(datetime,key)</div><div>)</div><div><br></div><div>Any idea is wellcome</div><div>I know there&#39;s many solutions, if i have &gt;100 columns, if datetime is sparse (only one key have values per datetime value), etc etc<span></span></div><br><br>-- <br><div dir="ltr"><div><div dir="ltr">Roberto Spadim<br>SPAEmpresarial - Software ERP<div>Eng. Automação e Controle</div></div></div></div><br>