gregfthompson
asked on
Transpose multiple call signs to correspond with code.
Excel worksheet;
Column A contains a code number in each row
Column B contains several call signs separated by a comma corresponding to the code number.
Objective:
script to separate each call sign against the code as per example in columns C and D.
eEexample-transpose-callsign-to-cod.xlsx
Column A contains a code number in each row
Column B contains several call signs separated by a comma corresponding to the code number.
Objective:
script to separate each call sign against the code as per example in columns C and D.
eEexample-transpose-callsign-to-cod.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Got it. Using 2016.
Very handy.
Many thanks Tom.
Very handy.
Many thanks Tom.
Glad to help.
The good news is you can add more rows to the data you provided me, and right-click the "Result Table" and select Refresh and the data will update for the new rows. Thanks for the points.