1.How to create categories and links list like the one below?
A K O
Alabama Kansas Ohio
Alaska Kentucky Oklahoma
... ....
B ....
British Columbia
...
C
California
Colorado
D
...
E
...
2.Is it possible to start every column from a new letter but still keep somewhat equal length of columns, not having a part of the same letter links/categories in one column and other part in next column?
Not like this:
... Connecticut
C
California D
Colorado Delaware
3. Is it possible to create this type of list by using "where" statement but still nicely split the list in multiple columns (for example only show the list of categories where Location_Type eq "County")? I only know how to use where statement after running the loop, but this way for column splitting calculation the script takes total number of categories not the number of items with "where" filter.
Many thanks in advance!
A K O
Alabama Kansas Ohio
Alaska Kentucky Oklahoma
... ....
B ....
British Columbia
...
C
California
Colorado
D
...
E
...
2.Is it possible to start every column from a new letter but still keep somewhat equal length of columns, not having a part of the same letter links/categories in one column and other part in next column?
Not like this:
... Connecticut
C
California D
Colorado Delaware
3. Is it possible to create this type of list by using "where" statement but still nicely split the list in multiple columns (for example only show the list of categories where Location_Type eq "County")? I only know how to use where statement after running the loop, but this way for column splitting calculation the script takes total number of categories not the number of items with "where" filter.
Many thanks in advance!