Alice, The basic solution is to use the List of People (LoP) report. With that report, you can produce a list of people with a column for ID, name, birth and death (if wanted), and a column for each of the 23 flags. A single TMG LoP report is limited to 9 output columns, which is too few to include all the columns described above. However, you can use multiple reports, then combine the results in Excel based on ID. So, for example. Report 1: ID, Name, Birth, Death Report 2: ID, Flag1, Flag2, Flag3, Flag4, Flag5, Flag6, Flag7, Flag8 Report 3: ID, Flag9, Flag10, Flag11, Flag12, Flag13, Flag14, Flag 15, Flag16 Report 4: ID, Flag17, Flag18, Flag19, Flag20, Flag21, Flag22, Flag23 You can combine the TMG LoP reports in Excel so that you have a row per ID with 27 columns total. Use the ID column to make sure you combine the reports properly. John

At 9/15/2015 16:14, you wrote: >The basic solution is to use the List of People (LoP) report. With >that report, you can produce a list of people with a column for ID, >name, birth and death (if wanted), and a column for each of the 23 flags. > >A single TMG LoP report is limited to 9 output columns, which is too >few to include all the columns described above. However, you can use >multiple reports, then combine the results in Excel based on ID. So, >for example. > >Report 1: ID, Name, Birth, Death > >Report 2: ID, Flag1, Flag2, Flag3, Flag4, Flag5, Flag6, Flag7, Flag8 > >Report 3: ID, Flag9, Flag10, Flag11, Flag12, Flag13, Flag14, Flag 15, Flag16 > >Report 4: ID, Flag17, Flag18, Flag19, Flag20, Flag21, Flag22, Flag23 > >You can combine the TMG LoP reports in Excel so that you have a row >per ID with 27 columns total. Use the ID column to make sure you >combine the reports properly. John & Donald - Coming in late on this (just back from a cruise to Bermuda!!), and maybe I am misunderstanding Alice's request since she indicates she likes your replies -- But, I interpreted her explanation to mean that each person is listed in lines (column 1), and columns 2 through ? would be for each Flag setting. So Flag XYZ with settings of "A", "B", and "C" would result in a table similar to this: Name A B C John X Jane X Bill X Mary X Joe X The actual Flag value could be used instead of the "X". Again, maybe I am wrong, but this was my impression. In any case, if I am right, I have no solution to the question as I am no expert on spreadsheets. I can do most of what I want with them, but for the exotic, I have to get help. I can program this in any of a half-dozen computer languages from flat files or databases, but not in spreadsheets. Anyway, is there an uncomplicated way to do the above from TMG? Quick thoughts are that it would have to be through a word processor and use of macros to create the table, and then take the table to the spreadsheet. This might work for small tables, but might be more complex than necessary for large tables. Lee

Lee, I interpreted Kathy's request differently. I thought she wanted a column per flag _field_, not per flag _value_. In Excel, one could split each flag field column, if desired, using a macro. I doubt that is what Kathy wants. Processing the values after each flag's values have been split into distinct columns would be tedious. Using Excel, or any database or analysis program, one can filter records by value so I don't see any advantage to splitting each flag field value into a distinct column. However, I am assuming that the set of values in each flag field are related to each other. If the values in any particular flag field are completely unrelated to each other ("Roses are red, violets are blue, I like ice cream, can you roller-skate?"), then Kathy should normalize the data. Keeping unrelated data in the same field is a recipe for confusion. John