Hi, I have 40 columns named 001,..., 040. They consist of up to 200 hundred NATURAL numbers. I need to create a macro that will copy values only from certain columns based on the strings I have to process (e.g. 002-040-017-023 or 009-008 or 006 etc.).
Example:
IN
001 002 003 004
1 2 3 0
2 4 7 1
3 6 9 2
4 8
5 10
OUT
001-004-002 004-003
0 0
1 1
2 2
3 3
4 7
5 9
6
7
8
9
10
Any idea? I was thinking about selecting values based on prefix from a column where I would store all column values (with prefixes representing column names). Then the macro would remove prefixes, blanks, duplicates and sort it out values. I am able to produce everything except for the function selection column values.
Bookmarks