Excel Tricks

-
1) Multiple Columns' Data to One Column.

Solution:

Open 'Developer' using Options > Ribbon.

Create 'Macro'.

Use the below code inside Macro:

    Range(Selection, Selection.End(xlDown)).Select
    Selection.Copy
    ActiveCell.Offset(0, 1).Range("A1").Select

Open clipboard.

Use Macro Shortcut to perform multiple copy.

Go to position and double click from Clipboard to paste the next columns.

Alternate Solution without Macro:
Use Clipboard, copy all columns individually, choose the position in the column for the values to be pasted, double-click the data to be pasted from the Clipboard. Repeat this until all data is pasted in the same Column.


Comments

Post a Comment

Popular posts from this blog

EWM PPF Trigger the existing PPF Action through Custom Program

-
Aim: Same as title Description: An Action has been scheduled for the Handling Unit in the EWM Monitor and we need to execute it in a Custom Program without executing it from the Monitor. What to do? Use the below code accordingly. Code: *&---------------------------------------------------------------------* *& Report ZAG_TEST_HU_PRINTING *&---------------------------------------------------------------------* *& *&---------------------------------------------------------------------* REPORT zag_test_hu_printing. PARAMETERS: p_hu TYPE /scwm/huident DEFAULT '154118660000024802'. DATA: lt_huhdr     TYPE /scwm/tt_huhdr_int,       lt_protocol  TYPE bal_t_logh,       lt_contexts  TYPE ppftcntxts,       lo_hu_ppf    TYPE REF TO /scwm/cl_hu_ppf,       lo_manager   TYPE REF TO cl_manager_ppf,       lt_trigger   TYPE ppfttr...
Read more

ABAP 7.5 - FILTER Statement

-
There are two internal tables, say, itab1 and itab2. Both are of the same definition. If the entries in itab2 should not be present in itab1, we use FILTER function along with 'EXCEPT IN'. There are two internal tables, say, itab1 and itab2. Both are of the same definition. If only the entries in itab2 should be present in itab1, we use FILTER function along with 'IN'. FILTER required SORTED / HASHED internal tables. Example program is below. REPORT  zag_75_filter1 . TYPES :  BEGIN  OF  lty_filter ,          field1  TYPE  i ,          field2  TYPE  i ,         END  OF  lty_filter ,        ltt_filter  TYPE  SORTED  TABLE  OF  lty_filter  WITH  NON-UNIQUE  KEY  field1 field2 . DATA :  lt_main   ...
Read more

Useful Transaction Codes / Tools in OData ABAP Service / SAP UI5/ SAP Fiori

-
Tips:   1) FND stands for 'Front End' 2) GW stands for Gate Way / Gateway S. No. Transaction Code Description 1 SEGW SAP Service Gateway Builder 2 /IWFND/ERROR_LOG SAP Gateway Error Log 3 /IWFND/APPS_LOG SAP Gateway Application Log Viewer 4 /IWFND/VIEW_LOG SAP Gateway Application Log Viewer 5 /IWFND/CACHE_CLEANUP Cleanup of GW Model Cache - GW stands for Gateway 6 /IWFND/TRACES SAP Gateway Traces 7 /IWFND/SRV_VALIDATE This transaction exists only on SAP Gateway 2.0 (Netweaver 7.31 and below) systems 8 /IWFND/REG_SERVICE Activate Services (Unavailable in latest releases) 9 /IWFND/MAINT_SERVICE Activate and Maintain Services 10 /IWFND/VIRUS_SCAN Configuration of SAP GW Virus Scan 11 SICF Edit HTTP Service Hierarchy 12 ...
Read more