How To Convert A Vertical List Into A Table In Excel

Here is how you can take a vertical list of products and their ingredients and convert that into a table for easier viewing. In the process we will use the COLUMNS, COUNTIF, and VLOOKUP functions.

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.

Happy Excelling!

Free Download!

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

No comments yet.

Leave a Reply