Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

Microsoft Excel 2010 can convert a worksheet to a data table to help you quickly analyze your related data in formatted rows and columns. When you need to expand the table layout, apply the Home ...

You can easily hide and unhide columns in Excel by individually revealing hidden columns or using the "Format" option to unhide all hidden cells.

Use Word 2010's Numbering feature in tables and make it automatically number multiple table columns vertically. This way, each cell in each column will be placed under the correct number.

In this article, the author shows how to use big data query and processing language U-SQL on Azure Data Lake Analytics platform. U-SQL combines the concepts and constructs both of SQL and C#.