'Excel function or VBA to solve Data in a single column Result required in multiple columns

DATA APPLE 2 BALL 3 CAT 4 DOLL 43 EGG 456

APPLE 23 BALL 344 CAT 123 DOLL 543 EGG 234

RESULT REQUIRED
APPLE BALL CAT DOLL EGG 2 3 4 43 456 23 344 123 543 234

Data is in excel file.

export-to-excel


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions