buckyzacker
New Member
- Joined
- Jul 19, 2012
- Messages
- 1
Hi All,
I have three lists:
Column A: 50 state names
Column B: List of types of autos (private passenger, light, medium, heavy, extra-heavy)
Column C: List of numbers (100, 200, 300, 400, 500, 600, 700, 800, 900, 1000).
I want to concatenate the three lists together to create unique identifiers so that there is a state/type/number for each possibility, which in this case would be 50x5x10=2,500 possibilities.
For example, the the results would start out:
Alabamaprivatepassenger100
Alabamaprivatepassenger200
Alabamaprivatepassenger300
and end with
Wyomingextra-heavy1000.
I appreciate your help.
Thanks.
I have three lists:
Column A: 50 state names
Column B: List of types of autos (private passenger, light, medium, heavy, extra-heavy)
Column C: List of numbers (100, 200, 300, 400, 500, 600, 700, 800, 900, 1000).
I want to concatenate the three lists together to create unique identifiers so that there is a state/type/number for each possibility, which in this case would be 50x5x10=2,500 possibilities.
For example, the the results would start out:
Alabamaprivatepassenger100
Alabamaprivatepassenger200
Alabamaprivatepassenger300
and end with
Wyomingextra-heavy1000.
I appreciate your help.
Thanks.