I have employees with certain tasks completed and each task creates a new record. I am looking to change the format so all tasks run as colums across the top and have created a crosstab for this purpose but it creates multiple rows for the employee. is there a way to merge the data into a single record/Row?
I need to export this data to a spreadsheet in this format.
EG: Employee 30 would look like
30 | 02/06/2070 | 02/06/2022 | 24/08/2023 | 02/06/2070 | 09/06/2022 | 02/06/2070 | 25/05/2067 | 28/04/2023 |
The number on the left is employee and the date is the task. each task has a separate column created by the crosstab query.
Any Help much appreciated.
I need to export this data to a spreadsheet in this format.
EG: Employee 30 would look like
30 | 02/06/2070 | 02/06/2022 | 24/08/2023 | 02/06/2070 | 09/06/2022 | 02/06/2070 | 25/05/2067 | 28/04/2023 |
The number on the left is employee and the date is the task. each task has a separate column created by the crosstab query.
Any Help much appreciated.