Apr 04 2020 03:18 AM
Hi,
The attached data set represents the different taxes paid by various taxpayers over a 3-year period. I wish to pivot the data so that I will have the TIN (Taxpayer Identification Number) and the the Taxpayer as row labels in the first two columns but on the same row. The TIN and the Taxpayer refer to one and the same person. It is therefore desirable to have them on the same row. I am having a challenge achieving that outcome. I am a beginner in excel. Th e attached workbook has three tabs showing the raw data, the pivot result I managed to achieve (after several tries) and the pivot result I actually desire.
I hope somebody can help.
Thanks in advance,
Sadorc
Apr 05 2020 02:06 PM
@Riny_van_Eekelen Hi Riny, Forgive me. I am new here and don't quite know my way around. I recall, though, that I did attach the workbook using the "browse files" option.
I have tried again but I got the following feeback:
The attachment's #sadorc.xlsx content type (application/vnd.openxmlformats-officedocument.spreadsheetml.sheet) does not match its file extension and has been removed
I'm afraid you may have to guide me in uploading the file. It is an excel workbook.
Thank you in advance
Apr 05 2020 10:01 PM
@sacord6465 Never had such a message myself, and I'm no expert on file types and formats, but it seems that you are not uploading a "regular" Excel file. It may have the xlsx extension, but the system somehow doesn't recognise it as such. Try this. Open your file in Excel, save it under a different name, make sure you choose the correct file format and upload again.
Apr 06 2020 07:26 AM
@Riny_van_Eekelen Thank you. Here we go.
Apr 06 2020 08:41 AM
@sacord6465 Not sure how your "Desired result" came about, but it doesn't seem to be in line with the underlying data. Have changed the lay-out of the PT and saved your file as an xlsx file.
Is this what you had in mind?
Apr 06 2020 11:47 AM
@Riny_van_Eekelen In fact my problem is basically a layout problem. The desired result is not a pivot table. It is an ordinary excel sheet in which I have entered the data the way I would like it to look to be laid out - to have the TIN field and the Taxpayer field on the same row. The result achieved is the pivot table I managed to produce based on the data and my facility with pivot tables. On it you would notice that the TIN and Taxpayer fields are in the same column but consecutive rows.
You are right there was a typo in the desired result sheet. I have corrected it.
Please find the corrected file attached.