1 2 Previous Next 19 Replies Latest reply on Feb 20, 2012 1:20 PM by philmodjunk

    Consolidate Fields into one

    AlexXander

      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

      .......

        1 2 Previous Next