demonfreak
New Member
- Joined
- Dec 11, 2016
- Messages
- 12
Hello,
I have a problem that I need help with. I have a set of data that contains 3 columns with variable numeral character counts. I need all rows to be concatenated and all 13 digits long (adding leading zeros where necessary.).
Here's an example set of data of what it is currently and what end results I'm looking for.
Thank you for any help.
I have a problem that I need help with. I have a set of data that contains 3 columns with variable numeral character counts. I need all rows to be concatenated and all 13 digits long (adding leading zeros where necessary.).
Here's an example set of data of what it is currently and what end results I'm looking for.
CL 1 | CL 2 | CL 3 | End Results |
1234 | 123 | 1 | 0123400012301 |
1234 | 1234 | 2 | 0123400123402 |
1234 | 12345 | 20 | 0123401234520 |
1234 | 123456 | 10 | 0123412345610 |
Thank you for any help.
Last edited: