Like the picture a want to make a query to do it automatically this process
1. First I want to take the blue horizontal cells (PF7,PF8, S1, S4 and S6) and transpose it to vertical as I show you with orange color
2. Second, how can I do to transpose and the same time fille every row with the respective ID , status, puntuation , (2282) as I show you in green color
Try looking at the steps in the attached example file.
Directions:
Highlight cells A6:C11
Enter this formula in the formula bar: =A2:C2
Confirm formula with Control + Shift + Enter
Do the same with the formula in cells D6:D11….
