How can I drag a formula horizontally so to update the cells from an array of data vertically arranged considering the data should be updated once the vertical array changes (Microsoft Excel)?

Answer 1

I believe I know what you are asking: you have data in a column, such as a2:a10, and you’d like it in a row, such as b1:j1. In addition, you’d like the row automatically updated when the column is updated.

Here is my answer:

Assuming your data is in column a2:a26,

in b1 enter the formula “=index($a1:$a26,column())”

Now copy that formula into c1:z1.

This does the job. If you have further questions, please ask.