Is this what you are looking for (you can rename the column headers)?
Excel 2016 (Windows) 32 bit
|
A |
B |
C |
D |
E |
F |
G |
H |
1 |
Project ID |
Project Name |
Project Critical |
Senior Manager |
Project Manager |
Points |
Value.1 |
Value.2 |
2 |
5014180000 |
Project 1 |
Yes |
Manager 1 |
Project Manager 1 |
0.098833403 |
14/05/2018 |
0 |
3 |
5014180000 |
Project 1 |
Yes |
Manager 1 |
Project Manager 1 |
0.098833403 |
30/04/2018 |
0 |
4 |
5014180000 |
Project 1 |
Yes |
Manager 1 |
Project Manager 1 |
0.098833403 |
03/09/2018 |
0 |
5 |
5014180000 |
Project 1 |
Yes |
Manager 1 |
Project Manager 1 |
0.098833403 |
02/10/2018 |
0 |
6 |
5014180000 |
Project 1 |
Yes |
Manager 1 |
Project Manager 1 |
0.098833403 |
13/05/2019 |
0 |
7 |
5014180000 |
Project 1 |
Yes |
Manager 1 |
Project Manager 1 |
0.098833403 |
05/08/2019 |
0 |
8 |
5014180000 |
Project 1 |
Yes |
Manager 1 |
Project Manager 1 |
0.098833403 |
04/12/2019 |
0 |
9 |
5014180000 |
Project 1 |
Yes |
Manager 1 |
Project Manager 1 |
0.098833403 |
02/06/2021 |
0 |
10 |
5011590000 |
Project 2 |
No |
Manager 2 |
Project Manager 2 |
0 |
02/07/2018 |
0 |
11 |
5011590000 |
Project 2 |
No |
Manager 2 |
Project Manager 2 |
0 |
18/06/2018 |
-4 |
12 |
5011590000 |
Project 2 |
No |
Manager 2 |
Project Manager 2 |
0 |
11/02/2019 |
-4 |
13 |
5011590000 |
Project 2 |
No |
Manager 2 |
Project Manager 2 |
0 |
03/07/2019 |
-3.857142857 |
14 |
5011590000 |
Project 2 |
No |
Manager 2 |
Project Manager 2 |
0 |
23/09/2020 |
-4 |
15 |
5011590000 |
Project 2 |
No |
Manager 2 |
Project Manager 2 |
0 |
23/12/2020 |
-4 |
16 |
5011590000 |
Project 2 |
No |
Manager 2 |
Project Manager 2 |
0 |
13/01/2021 |
-4 |
17 |
5011590000 |
Project 2 |
No |
Manager 2 |
Project Manager 2 |
0 |
21/09/2022 |
-4 |
18 |
5012900000 |
Project 3 |
No |
Manager 1 |
Project Manager 2 |
0 |
16/04/2018 |
0 |
19 |
5012900000 |
Project 3 |
No |
Manager 1 |
Project Manager 2 |
0 |
24/12/2015 |
0 |
20 |
5012900000 |
Project 3 |
No |
Manager 1 |
Project Manager 2 |
0 |
16/04/2018 |
0 |
If so, have a look at the attached, which uses this M code in the PowerQuery and merges columns before pivoting them:
Bookmarks