Transposing data from column to row using references

excel excel-formula transpose formulas array-formulas
user1279207 picture user1279207 · Mar 19, 2012 · Viewed 18.2k times · Source

I have some data in a row, say A1 to Z1, and I would like to link to this data in another spreadsheet. However I would like to transpose it so the data runs from A1 to A26. It is important that it is linked in some type of function so that if I change the data on the first sheet, the second sheet is updated as well.

I'm thinking of some type of formula that states that as you go down a cell in column A, it knows to grab the data from the next cell to the right in Row 1. So: A2=B1; A3=C1; A4=D1 ...

Any ideas?

Answer

Related questions

Excel: Formulas for converting data among column / row / matrix

Are there formulas to convert data in a column to a matrix or to a row? And to convert from/to other combinations? What about an even more complex case: reshape a matrix of width W to width N*W? …

Read More
Shortcut to Apply a Formula to an Entire Column in Excel

If I select a cell containing a formula, I know I can drag the little box in the right-hand corner downwards to apply the formula to more cells of the column. Unfortunately, I need to do this for 300,000 rows! Is …

Read More
Remove leading or trailing spaces in an entire column of data

How do I remove leading or trailing spaces of all cells in an entire column? The worksheet's conventional Find and Replace (aka Ctrl+H) dialog is not solving the problem.

Read More