MS Excel

Many times situation occurs when it is required to move rows data to column in MS excel. This can be done very easily through Excel Formula, however the the manual process of doing the same is hefty. Suppose there is a file in following format: Emp Code Emp Name Salary Apr-17 Salary of May-17 …….

Many times while working in Excel, it is necessary required to copy only subtotal rows in Microsoft Excel as shown in below picture. Following are the way to copy only subtotal rows in Excel. Read – How to Move Rows Data to Column in Excel Hide the Detail Rows i.e. Show only Sub-total Rows as…