Hello All,
I'd be grateful for your help with this one.
A data sample is below:
I want create a table with 3 columns like this:
Whats the best way to do this please.
Many thanks. Rob
I'd be grateful for your help with this one.
A data sample is below:
Name | Course 1 | Course 2 | Course 3 | Course 4 | Course 5 | Course 6 |
Andrew | 05-05-2022 | 05-05-2022 | 05-05-2022 | 05-05-2022 | 08-03-2024 | 08-03-2024 |
Bev | 05-05-2022 | 05-05-2022 | 05-05-2022 | 05-05-2022 | 05-05-2022 | 05-05-2022 |
Charlotte | 06-04-2023 | 06-04-2023 | 06-04-2023 | 06-04-2023 | 30-03-2024 | 30-03-2024 |
Elena | 05-05-2022 | 15-03-2024 | 05-05-2022 | 05-05-2022 | 05-05-2022 | 05-05-2022 |
Emma | 07-07-2022 | 07-07-2022 | 07-07-2022 | 07-07-2022 | 29-03-2024 | 29-03-2024 |
Jill | 05-05-2022 | 05-05-2022 | 27-03-2024 | 05-05-2022 | 27-03-2024 | 27-03-2024 |
I want create a table with 3 columns like this:
Name | Course Title | Date |
Andrew | Course 1 | 05-05-2022 |
Andrew | Course 2 | 05-05-2022 |
Andrew | Course 3 | 05-05-2022 |
Andrew | Course 4 | 05-05-2022 |
Andrew | Course 5 | 08-03-2024 |
Andrew | Course 6 | 08-03-2024 |
Bev | Course 1 | 05-05-2022 |
Bev | Course 2 | 05-05-2022 |
Bev | Course 3 | 05-05-2022 |
Bev | Course 4 | 05-05-2022 |
Bev | Course 5 | 05-05-2022 |
Bev | Course 6 | 05-05-2022 |
Whats the best way to do this please.
Many thanks. Rob