You can import the text file data into the worksheet firstly, and then create Pivot Table with the imported data. Please do as follows.
Unaweza kuingiza data ya faili ya maandishi kwenye lahakazi kwanza, na kisha kuunda Jedwali la Pivot na data iliyoletwa. Tafadhali fanya kama ifuatavyo.