Bring the cursor to the right-bottom corner of cell B11. It’ll look like a plus (+) sign. It’s the Fill Handle tool. Drag this tool up to cell G11, horizontally.Drag the Fill Handle tool up to cell G18, vertically.We have the transposed dataset, but it’s not formatted....
Our objective is to create a two-way table (officially known as a cross-tabular structure); one that lists the Projects to the left and the Departments across the top. At the intersection of each “Project/Department” combination we wish to see all Persons assigned to the said combination....