I need to create a Custom Pivot table rows with custom text.
i need to cells containg 'word A' and 'Word B' and group them into data on a pivot table

Ex.
'Word A' french tutor toronto
'Word A' english tutor toronto
'Word A' spanish tutor toronto
'Word B' french tutor toronto
'Word B' english tutor toronto
'Word B' spanish tutor toronto

and come out with a table with containing Row data with
'Word A'
'Word B'

I really Need HELP Please!