I have the data of ‘k’ (>1000)companies (C) and each company is having   ‘N’ variables(=18)  as a time series ( dates). But, the starting date i.e. first non_zero or non_null or non_blank value for each company is not same. Date C1var1 C1var2 …. C1varN C2var1 C2var2 ….. C2varN …. CKvar1 CKvar2 … CKvarN 1/1/2018                           2/1/2018         1279.38 70 …. 70       ….   3/1/2018 1515.61 82.8 ….. 83.3 1320.59 67   72.5           4/1/2018 1537.17 81.25   85.25 1364.19 70   72.9   1221.88 68   68 5/1/2018 1464.34 81.4   81.85 1321.55 72   73   1240.57 63.1   66.9 6/1/2018 1449.96 77.55   78.7 1256.86 68.7   68.7   1254.94 64.55   66.9 7/1/2018 1338.32 76.9   76.9 1243.92 66   66.85   1232.9 67   69.85   I have to pickup the data of each company at its starting point and each variable should be in same column as follows Company Date Var1 Var2   Vark C1 3/1/2018 1515.61 82.8   83.3 C2 2/1/2018 1279.38 70   70 … …       … CK 4/1/2018 1221.88 68   68   What would be the best codes e to get the data in desired format Version 9.4 ... View more