AnsweredAssumed Answered

Consolidate Fields into one

Question asked by AlexXander on Feb 11, 2012
Latest reply on Feb 20, 2012 by philmodjunk

Title

Consolidate Fields into one

Post

Hi what I am looking at doing is finding a way to consolidate several fields (100) into one field creating one list. The 100 fields are 2000 records long but not all records are needed. Just all of the records greater than zero.

 

So what i am trying to do is this:

2     7     9     0

0     8     0     1

0     4     2     9

Would make the list

2        or      2

0                 7

0                 8

7                 4

8                 9

4                 2

9                 ......

0

2

.......

Outcomes