Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I have a simple spreadsheet that is the result of selecting records
from a database, and exporting the results to a .csv. Column 1 is a user name Column 2 is a title associated with a database column Column 3 is the data associated with the database column There are approximately 20 database columns which are referenced in this spreadsheet, thus each user will have up to 20 records in the sheet. All I want is to pivot the data, and perform no calculations against it. I only want to show what value is associated with each database column for each user. Can Pivot Tables do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to show data greater than 10 in pivot table | Excel Discussion (Misc queries) | |||
Pivot table Data refresh | Excel Worksheet Functions | |||
Do Pivot Tables have an automatic data range expansion? | Excel Discussion (Misc queries) | |||
Pivot Tables | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |