Category Archives: Code

Multiple into one columns and vice versa in Excel using macro

If you work with a lot of data in Excel, it is difficult to rearrange multiple column of data into a single column. The traditional way, you cut/copy and paste, and it will take forever (boring and repetitive works). The … Continue reading

Posted in Code | Tagged , | Leave a comment

Change the summary calculation of multiple pivot table fields at once using Macro (Excel)

Pivot table is useful to summary calculation for table. However, there isn’t a simple way to adjust multiple fields to the same function. The traditional way, you can right-click on the pivot table and adjust one-by-one. Fortunately, there is the easy … Continue reading

Posted in Code | Tagged , , | Leave a comment

Read/edit the built-in Matlab functions

I found a good tip from the matlab community to find out the built-in function in Matlab. You can edit and change it. The tip as follows: % You can use the [which] command to find the path name to … Continue reading

Posted in Code | Tagged , , | Leave a comment