Avatar of Lia Nungaray
Lia Nungaray
Flag for United States of America

asked on 

Pivot Table without Summarizing

I have one table which holds configurations and I am trying to create a query to extract the setting for two clients and compare them. The table looks something like this:

1000              80                                      Y
1000              88                                      Y
1000              89                                      N
1000              102                                      Y
3000              89                                      N
3000              90                                      Y
3000              102                                      N
3000              124                                      Y
3000              330                                      N

I tried creating a pivot table in Excel, but the values are summarized. Is there a way to create a pivot table without summarizing the values?
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Gary Benjamin

8/22/2022 - Mon