How to Copy only Subtotal Rows : Excel

How to Copy only Subtotal Rows : Excel

Many times while working in Excel, we need to copy only subtotal rows. Following are the way to copy only subtotal rows in Excel.

Formula for transposing data from Row to Column: MS Excel

Formula for transposing data from Row to Column

Recently I have encountered a situation where I have to transpose the row data to column in Excel. The manual process was totally impossible due to high volume of data. One can easily understand the requirement from the below format: 

Original File Format:

Emp Code	Emp Name	Sal Month-01	Sal Month-02	…	Sal Month-41
111	Emp1	123	124	124	145
112	Emp2	…	…	…	…
113	Emp3	…	…	…	…
…	…	…	…	…	…
999	Emp999	…	…	…	…

How to create a Role for SU01 Display - SAP Basis

Role for SU01 Display - SAP Basis

Introduction: As a SAP Basis Consultant / Administrator you may get the requirement that functional consultants require SU01 display authorization.

How to do:

1) This is very simple.

2) Do not think to create a role with SU01 tcode and modify that for display only.

How to add request manually in transport queue - SAP Basis

Introduction : As a SAP basis consultant / administrator some time you feel the requirement of adding a request manually in transport queue.

How to do :
1) tcode STMS_IMPORT (You will see requests in the queue. You want to add another request which is not available in the queue.).

2) Select Menu ( Extras - Other Requests - Add) as shown below.

How to add multiple server instances in single MMC - SAP Basis

Introduction: As a SAP Basis Consultant / Administrator you will always feel the requirement to manage/ monitor your organizations all SAP servers from your workstation. This may be achieved by adding multiple server instances (ABAP and JAVA Systems) in a single MMC. Follow below steps to add multiple service instances in single MMC.

How to do:

1) Start SAP MMC