Forum Discussion
Solved
Grouping and summarizing into rows with column data
Have set of Site information that outputs data into various rows. Need to summarize all those invidiual SiteNo's with data in their own columns. Have been working at this for a while before request...
You should be able to do this all from the UI:
- Remove the unneeded columns "Code" and "Oid
- Pivot the "Description" Column
- Values Column = Text
- Advanced Options => Don't Aggregate
- Then reorder your columns as you wish
You should be able to do this all from the UI:
- Remove the unneeded columns "Code" and "Oid
- Pivot the "Description" Column
- Values Column = Text
- Advanced Options => Don't Aggregate
- Then reorder your columns as you wish