Forum Discussion
Formula for vertical to horizontal data
I have data in E2-E1044 of Sheet 5 that I want to display in Sheet 1, shown below. The data may change, so I want to show the cell rather than just copy and paste current cell contents. The data sho...
To make a dynamic reference, you will have to use INDIRECT, CONCATENATE and ROW to get the results you're looking for. See the sample workbook below of it is used.
Cells in yellow show three unique formula set ups to make it easy to drag and pull down the formulas. To simply pull the formulas down, you will need to select the entire row (example E3:K3).