How To Convert A Vertical List to a Data Range In Excel

Previously I did a post to convert a data range to a single column. In this video I will do the opposite – convert a single column into a data range or table. We will use the OFFSET, ROWS, and COLUMNS functions in the process.

You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.

The previous post to convert a Data Range to a list can be found here.


 

What can you do next?
Share this post with others that can benefit from it!
Leave a comment or reply below – let me know what you think!
Subscribe to this blog for more great tips in the future!
Check out my YouTube channel – click on the YouTube icon below!

Happy Excelling!

Related Post

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

, , , , , ,

2 Responses to How To Convert A Vertical List to a Data Range In Excel

  1. maj May 14, 2015 at 4:54 pm #

    Nice

Leave a Reply