A case statement along with aggregation might do the trick - http://stackoverflow.com/questions/13372276/simple-way-to-transpose-columns-and-rows-in-sql/13377114#13377114
On Mon, Jun 13, 2016 at 11:35 PM, Sanjiv Kumar <[email protected]> wrote: > Then, how to convert row data to column using Apache Drill ? > > > ...................... > Thanks & Regards >
