I have seen multiple threads on this subject but most are more complex than I need.
Basically I just want to combine the data from selected column (e.g. Col A) and concat that with data in target column (e.g. Col B) however I want to specify the number of imbedded spaces between the two values (e.g. 30 blanks).
Col A...............................Col B (before)b.................................Col B (after)
A1001............................SERVER COMPUTER...................SERVER COMPUTER.................A1001
A1022.............................SWITCH 24 PORTS...................SWITCH 24 PORTS.................A1022
A1038.............................SWITCH ROUTER......................SWITCH ROUTER...................A1038
I would be preferable if I can select blocks of rows in Source Column to concat same in target column. Thanks in Advance!
Bookmarks