Forum Discussion
Solved
Summarizing of text data in pivot tables.
My task involves manipulation of gene sequencing data. The description of the task is simplified to focus on key issues. I have text data relating to a single gene that is spread over multiple rows...
To do that with PivotTable you need to add data to data model creating it and add measure like
Measure:=CONCATENATEX(Table1,Table1[Data])and use it as
To do that with PivotTable you need to add data to data model creating it and add measure like
Measure:=CONCATENATEX(Table1,Table1[Data])and use it as
- Thanks for your help. Not what I would call intuitive but it works.
DavidBridges , you are welcome
