Pivot table display without calculation
Yann
-
via55 Posted messages 14730 Registration date Status Membre Last intervention -
via55 Posted messages 14730 Registration date Status Membre Last intervention -
Hello,
I’m posting on this forum because I’m having an issue with my pivot table.
Here is my base table:
Stop Names Time Bus No.
Stop 1 04:00 11111
Stop 2 05:00 11111
Stop 1 08:00 22222
Stop 2 09:00 22222
Here is the pivot table I would like to have:
BUS NO: 11111 22222
Stop Names:
Stop 1 04:00 08:00
Stop 2 05:00 09:00
However, when I create the pivot table, all the times display as follows:
BUS NO: 11111 22222
Stop Names:
Stop 1 00:00 00:00
Stop 2 00:00 00:00
Could you please help me with a solution?
Thank you in advance if anyone can assist me.
Configuration: Windows 7 / Chrome 52.0.2743.82
I’m posting on this forum because I’m having an issue with my pivot table.
Here is my base table:
Stop Names Time Bus No.
Stop 1 04:00 11111
Stop 2 05:00 11111
Stop 1 08:00 22222
Stop 2 09:00 22222
Here is the pivot table I would like to have:
BUS NO: 11111 22222
Stop Names:
Stop 1 04:00 08:00
Stop 2 05:00 09:00
However, when I create the pivot table, all the times display as follows:
BUS NO: 11111 22222
Stop Names:
Stop 1 00:00 00:00
Stop 2 00:00 00:00
Could you please help me with a solution?
Thank you in advance if anyone can assist me.
Configuration: Windows 7 / Chrome 52.0.2743.82
1 réponse
Hello Yann
A pivot table is used to perform calculations (sum, average, etc.), but that's not what you're looking for; you simply want to reorganize your data into another table
Therefore, you need to build this table with bus numbers in columns and stop names in rows, then use an array formula to fill the cells at the intersection of each row and column with the schedules
Example to adapt to your file:
http://www.cjoint.com/c/FHflIjDwWEE
Best regards
Via
--
"Imagination is more important than knowledge." A. Einstein
A pivot table is used to perform calculations (sum, average, etc.), but that's not what you're looking for; you simply want to reorganize your data into another table
Therefore, you need to build this table with bus numbers in columns and stop names in rows, then use an array formula to fill the cells at the intersection of each row and column with the schedules
Example to adapt to your file:
http://www.cjoint.com/c/FHflIjDwWEE
Best regards
Via
--
"Imagination is more important than knowledge." A. Einstein
The formula with INDEX will look for the value in column B that is on the row equivalent to where we find in A the name of the stop and in C the bus number (hence the & in the formula to concatenate the 2 pieces of information and the 2 columns; this is what requires doing it as an array formula).