You can do it this way SELECT month, MAX(CASE WHEN unit=”CS-1″ THEN value END) `CS-1`, MAX(CASE WHEN unit=”CS-2″ THEN value END) `CS-2`, MAX(CASE WHEN unit=”CS-3″ THEN value END) `CS-3` FROM ( SELECT unit, month, CASE month WHEN ‘JAN’ THEN jan WHEN ‘FEB’ THEN feb WHEN ‘MAR’ THEN mar WHEN ‘APR’ THEN apr WHEN ‘MAY’ THEN … Read more
The idea is to give here something that can likely be used with minor adaptations to the questions listed above, which may also serve as a reference for future related questions. The essential functions to be used are INDEX or OFFSET. The pros and cons of each one will be given after explicit examples, with … Read more
You cannot concatenate a range of cells (aka Letters) using native worksheet functions without knowing the scope beforehand. As your collection of strings into groups has random numbers of elements, a VBA loop approach seems the best (if not the only) way to address the issue. The loop can make determinations along the way that … Read more
If the whole file contents fits into memory, you can use import csv from itertools import izip a = izip(*csv.reader(open(“input.csv”, “rb”))) csv.writer(open(“output.csv”, “wb”)).writerows(a) You can basically think of zip() and izip() as transpose operations: a = [(1, 2, 3), (4, 5, 6), (7, 8, 9)] zip(*a) # [(1, 4, 7), # (2, 5, 8), # … Read more
t does not rotate the entries, it flips along the diagonal: x <- matrix(1:9, 3) x ## [,1] [,2] [,3] ## [1,] 1 4 7 ## [2,] 2 5 8 ## [3,] 3 6 9 t(x) ## [,1] [,2] [,3] ## [1,] 1 2 3 ## [2,] 4 5 6 ## [3,] 7 8 9 … Read more
You can use df = df.T to transpose the dataframe. This switches the dataframe round so that the rows become columns. You could also use pd.DataFrame.transpose().
Worksheets(“Sheet1”).Range(“A1:A5”).Copy Worksheets(“Sheet2”).Range(“A1”).PasteSpecial Transpose:=True
I’m assuming that you have this array: $array = array ( array (’01’,’03’,’02’,’15’), array (’05’,’04’,’06’,’10’), array (’07’,’09’,’08’,’11’), array (’12’,’14’,’13’,’16’) ); In which case, you can do this: $tmpArr = array(); foreach ($array as $sub) { $tmpArr[] = implode(‘,’, $sub); } $result = implode(‘|’, $tmpArr); echo $result; See it working
As Kris Roofe stated in his deleted answer, array_column is indeed a more elegant way. Just be sure to put it into some kind of a foreach loop, similar to what Sahil Gulati showed you. For example, like this: $result = array(); foreach($where[‘id’] as $k => $v) { $result[] = array_column($where, $k); } The var_dump … Read more
My personal favourite is this gist: function transpose(a) { return Object.keys(a[0]).map(function (c) { return a.map(function (r) { return r[c]; }); }); }