Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | J | |||
1 | Exported On: 16/08/2019 15:40:57 | |||||
2 | Employees.Forename | Employees.Surname | PaymentHistory.PaymentHrsNoCur | PaymentHistory.PaymentDescription | ||
3 | User | one | 45 | Basic Pay | ||
4 | User | one | 10.03 | Overtime | ||
5 | User | two | 38.5 | Basic Pay | ||
6 | User | three | 45 | Basic Pay | ||
7 | User | three | 10.25 | Overtime | ||
8 | User | Four | 45 | ARTIC RATE | ||
9 | User | Four | 9.03 | ARTIC OVERTIME | ||
10 | User | Five | 24 | Basic Pay | ||
11 | User | six | 24 | Basic Pay | ||
12 | User | Seven | 45 | Basic Pay | ||
13 | User | Seven | 4 | Overtime | ||
14 | User | Eight | 45 | ARTIC RATE | ||
15 | User | Nine | 43 | Basic Pay | ||
16 | User | Ten | 45 | Basic Pay | ||
17 | User | Ten | 2.12 | Overtime | ||
18 | User | Eleven | 44 | Basic Pay | ||
19 | User | Twelve | 44 | Basic Pay | ||
20 | User | Fourteen | 44 | Basic Pay | ||
21 | User | Fifteen | 45 | Basic Pay | ||
22 | User | Fifteen | 11.12 | Overtime | ||
23 | User | Sixteen | 45 | Basic Pay | ||
24 | User | Sixteen | 5.24 | Overtime | ||
25 | User | Sixteen | 5.53 | Time and a half | ||
Raw Data |
I just copied your data to a blank sheet, lined up to match the rows and columns as shown in your example, then got the results as shown in your other thread by using the following steps.
-Go to the Data tab on the excel ribbon, then choose 'From Table/Range'.
-In the popup box, enter =$A$2:$J$25 and tick the headers box.
-In the PQ editor, select the 'PaymentHistory.PaymentDescription' column.
-Go to the Transform tab, then choose 'Pivot Column'.
-Change the dropdown to 'PaymentHistory.PaymentHrsNoCur'.
-Close the editor and Keep changes.