 <p>It seems that what you want to do is to split that Comment column into it's on data stream?</p> <p>After the transpose, you can crosstab into a form that contains the products as headers and the dates and comments as individual rows. Then a filter can pull the comment row out. A sort on the Name field would also let you grab the last row in that dataset to know which one was the last date.</p> <p>For the crosstab:<br> - Grouping Fields: Name<br> - Header Field: Product<br> - Data Field: Value</p> <p>Methodologies: Concatenate</p>