Split each field in a table to separate tables

[rgusaas]

I need to split each field in a large table into separate tables. I know how to do it using the Select tool but wondered if there was another method that would save me the time of mapping 330 fields. I will only want the distinct values for each field also.

Any ideas would be greatly appreciated.

[MarqueeCrew · Accepted solution]

Using a TRANSPOSE tool followed by a Summarize, you'll get the sets of field names and values that are unique.  I then use the field name to help construct the table name and create equal tables all having 1 column of "Value" containing the unique set of domain values for the given field name.

Cheers,

Mark