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