I've got a table such as this:
I want the transposed sheet to update whenever I update the original sheet.
I've tried to add another line beneath the transposed table, at line 4, and pulling all the appropriate names:
Cell A (Transposed) <- Cell B (Original) (the <- means pull the contents of Cell B into Cell A).
A4 <- Sheet1!D1
B4 <- Sheet1!D2
C4 <- Sheet1!D3
D4 <- Sheet1!D4
The problem is, when I try to autocomplete the next line using the little plus (+) mark at the bottom of my selection, lo and behold what happens:
It makes cell A5, which should pull from cell Sheet1!E1, pull from cell Sheet1!D2 instead!
How do I auto-complete this correctly, without writing every single cell myself?