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.

How to Change Columns Into Rows in Excel 2007. If you've ever entered a long list of business data and realized you need this information across a row instead of down a column, you can take ...

Select Unhide Columns from the drop-down menu to reveal all hidden columns within your selection, or select Unhide Rows to do the same for rows.