To do a partial transpose, you need to use the worksheet function INDEX.ġ. budgets or working on payroll within Excel. This happens when you are collating sales forecasts, But if you are planning to transpose partially so that you can use the data as a Pivot Table source, then the solution is not as straight forward. The data is immediately re-arranged with the dimensions switched, from rows to columns and columns to rows. Just copy the data, goto Paste Special and check on the transpose box found in the Paste Special window.
Transposing data in Excel is pretty straight forward.
