Loading...

Change Horizontal Data to Vertical - Excel TRANSPOSE Function

280,966 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Jan 8, 2011

http://www.contextures.com/30excelfun... Use the TRANSPOSE function in Excel to change vertical data to horizontal, or vice versa.

If you don't need to keep links to the original data, use the Paste Special Transpose command instead.

You can use the TRANSPOSE function to do the following:

--Change data orientation from horizontal to vertical
--Use it with other functions to total a range of cells

Watch this video to see how to use the Excel TRANSPOSE function, and combine it with other functions.

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...