You can use calculations with either the INDEX or TRANSPOSE functions. In real life, you might need to do calculations instead of copying the data.
If cells in column A change, they will change in row 2.Īdditional Details: The example in this topic is a trivial example of merely copying the cells. The advantage of using TRANSPOSE over using Paste Special, Transpose is that the TRANSPOSE function is a live formula.
Microsoft excel fill column with formula how to#
I need to use formulas to pull this information into a horizontal table. In this MS Excel tutorial from ExcelIsFun, the 605th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF function to fill in column with missing values then use Paste Special Values to create the final column with correct values. Problem: Every day, I receive a file with information going down the rows.