I have a table with many state and county values listed in separate rows. I want to flatten the attributes so that each CessionID has states and counties listed in separate fields. For example, State1 would contain the first state, County1 would contain the list of counties within the State1, then State2 would be the second state, County2 the list of counties in State2 separated by semicolons, and so on. See example in attached spreadsheet.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
- 7843 replies
Hi @nrobbins, if I understood the requirement correctly, this workflow might help you.
