how to convert an existing sheet of excel of trial balance ito pivot table

hi,
i have an issue that when i try to convert my datasheet of trial balance into pivot table.. it does not give me the desired result.. it does not show the data as in source file.. wat should i do to create an authentic trial balance reporting.. as i want that user should only do the data entry and i'll get the report through pivot table..

fisrt step, upload a copy of you worksheet, put in dummy information if it contains sensitive data