Hi Everyone,
I need a macro for transferring data from vertical to horizontal.
I have like this
ID Name
ENVM100010 TYPE
ENVM100010 COMPRISING
ENVM100010 SIZE/DIMENSIONS
ENVM100010 MATERIAL
ENVM100010 RATING/CAPACITY
ENVM100010 APPLICATION
ENVM100010 STANDARDS
ENVM100010 PACKAGE DATA
ENVM100010 ADDITIONAL INFO
I need like this
ENVM100010 TYPE COMPRISING SIZE/DIMENSIONS MATERIAL RATING/CAPACITY APPLICATION STANDARDS PACKAGE DATA ADDITIONAL INFO
like this for many id and names
I need a macro for transferring data from vertical to horizontal.
I have like this
ID Name
ENVM100010 TYPE
ENVM100010 COMPRISING
ENVM100010 SIZE/DIMENSIONS
ENVM100010 MATERIAL
ENVM100010 RATING/CAPACITY
ENVM100010 APPLICATION
ENVM100010 STANDARDS
ENVM100010 PACKAGE DATA
ENVM100010 ADDITIONAL INFO
I need like this
ENVM100010 TYPE COMPRISING SIZE/DIMENSIONS MATERIAL RATING/CAPACITY APPLICATION STANDARDS PACKAGE DATA ADDITIONAL INFO
like this for many id and names