Pivot Table

%3CLINGO-SUB%20id%3D%22lingo-sub-500181%22%20slang%3D%22en-US%22%3EPivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-500181%22%20slang%3D%22en-US%22%3EHello%20All%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20created%20an%20excel%20table%20with%20all%20the%20census%20tracts%20in%20NY%20and%20what%20Congressional%20District%20each%20tract%20is%20in.%20I%20am%20trying%20to%20create%20a%20pivot%20table%20that%20provides%20a%20list%20of%20all%20tracts%20within%20a%20district.%20For%20example%2C%20one%20column%20would%20be%20the%20Congressional%20Districts%20and%20a%20second%20column%20would%20have%20a%20list%20of%20each%20tract%20(1%2C%202%2C%203%2C%20etc...).%20I%20know%20if%20you%20show%20details%20you%20see%20all%20the%20tracts%20in%20the%20district%2C%20but%20want%20to%20know%20if%20it%20is%20possible%20to%20create%20a%20table%20(or%20add%20another%20column%20in%20the%20table)%20that%20gives%20a%20list%20of%20each%20tract.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-500181%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Visitor
Hello All,

I created an excel table with all the census tracts in NY and what Congressional District each tract is in. I am trying to create a pivot table that provides a list of all tracts within a district. For example, one column would be the Congressional Districts and a second column would have a list of each tract (1, 2, 3, etc...). I know if you show details you see all the tracts in the district, but want to know if it is possible to create a table (or add another column in the table) that gives a list of each tract.

Thank you