Lists

Numeric Lists

• 01) ABCDEF – Build List With NO Separation
• 02) A B C D E F – Build List Separated by Space
• 03) A,B,C,D,E,F – Build List Separated by Comma
• 04) A, B, C, D, E, F – Build List Separated by Comma Space
• 05) A , B , C , D, E, F – Build List Separated by Space Comma Space

Line Feed

• 06) A {LF} B {LF} C {LF} D – Build List Separated By Line Feeds
• 07) A {LF} B {LF} – Build List Separated By Line Feeds Keep Rows Together

Alpha Lists (Quoted)

• 08) ‘A’ ‘B’ ‘C’ ‘D’ ‘E’ ‘F’ – Build List Wrapped in Quotes and Separated by Space
• 09) ‘A’,’B’,’C’,’D’,’E’,’F’ – Build List Wrapped in Quotes and Separated By Commas

Name Your Separation Character

• 10) A ? B ? C ? D ? E ? F – Build List Separated by a Defined String (See Option 11 Below)
• 11) Specify a Separation String, (See Option 10 Above)

Specialty For UniData Tables

• 12) Add COL.HDG – Build List, Repeats each ITEM with COL-HDG syntax

Generate Random Lists

• 13) Generate a Random List of 5,000 Names
• 14) Generate a Random Division Order Deck
• 15) Generate Two Slightly Different Division Order Decks

Other

• 16) Flip Row 3 Headers – Helps with VLOOKUPS after Running Compare Data Sets Routine

Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc