Forum Discussion
Help with this query, totally challenge
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...
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….