How to Use the Transpose Function in Excel

1. Highlight the range of cells where you want the transposed data to appear. For example, if you want to transpose cells A1:A10 into a row in cells B1:K1, you would highlight B1:K1.
2. Go to the 'Formulas' tab and click on 'Insert Function.' Type 'Transpose' in the 'Search for a function' field and click on the 'Go' button. Select 'Transpose' from the 'Select a function' section and click 'OK.'
3. Highlight the range of cells you would like to transpose. In our example, we would highlight cells A1 through A10. The range will appear in the 'Array' field of the Function Arguments window.
4. Hit 'Ctrl,' 'Shift' and 'Enter' on your keyboard simultaneously. The transposed data will appear in the new location, which is B1 through K1 in the example.