Hello,

I’m looking for an opportunity to create a crosstab (pivot) query, but I can’t get many examples from google.

For example:

Table A

Year, month, day, person, sign

2017  9         1      1        A

2017  9         2      1        B

2017  9         3      1        B

2017  9         ..30  1        C

2017  9         1      2        A

2017  9         ,,30  2       B

I woult like to get this:

Person         day1, day2, day3, day4, day5…day30

1                 A       B       B                          C

2                 A       B

Is this possible?

Many thanks.

Best regards

Olaf