View original (French)

Pivot table display without calculation

Yann -  
via55 Posted messages 14393 Registration date   Status Member 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

1 answer

  1.
    via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759
     
    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
    0
    1. Yann
       
      Thank you, that's exactly it :) !!! I have some trouble with the formula but it's perfect.
      0
      1. via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759 > Yann
         
        Re

        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).
        0