Transposing field data by subgroup 1

[TrekBiker]

I have starting data in the form

Category 1, Company 1, Comment1
Category 1, Company 1, Comment2
Category 1, Company 1, Comment3
Category 1, Company 1, Comment4
Category 1, Company 2, Comment5
Category 1, Company 2, Comment6
Category 1, Company 2, Comment7
Category 1, Company 2, Comment8
Category 1, Company 2, Comment9

Category 2, Company 3, Comment10
Category 2, Company 3, Comment11
Category 2, Company 3, Comment12
Category 2, Company 3, Comment13
Category 2, Company 3, Comment14
Category 2, Company 3, Comment15
Category 2, Company 4, Comment16
Category 2, Company 4, Comment17
Category 2, Company 4, Comment18
Category 2, Company 4, Comment19
etc.

There are many Categories, each with varying numbers of Companies.

For part of the analysis I want the data to be in the form

Category 1, Company 1, Comment 1, Comment 2, Comment 3, Comment 4
Category 1, Company 2, Comment 5, Comment 6, Comment 7, Comment 8, Comment 9
Category 2, Company 3, Comment 10, Comment 11, Comment 12, Comment 13, Comment 14, Comment 15
Category 2, Company 4, Comment 16, Comment 17, Comment 18, Comment 19

So for all combinations of Category and Company, transpose the comments and then take out duplicate rows.

Any suggestions welcomed.

 

[TrekBiker]

Hi Duane

Sorry for delay in awarding a star, trip to Slovenia meantime. This is great. The only glitch was that I'd used 'Comments' as the field name in my input table, not 'Comment'.

Now works a treat, many thanks.