Consider the following scenario illustrating the data I have vs. the data I want. Very simply, I have a single column that represents Field 1, Contents of Field 1,…etc. and is more appropriately formatted as pairs of rows across columns.
I've been experimenting with the
TRANSPOSE function, but that one's new to me and I'm not sure it's the right direction. At first glance, it doesn't seem to accomodate my needs. But I could be wrong…
While it would be relatively simple to set up an 'every other row' formula, I also have to account for situations where I may have a
foo repeating with a single
bar or vice versa, and that's where I'm stuck. What I need is a "next unused cell" function, or something that can add X rows or Y columns to a particular cell.
I can envision a formula that can manipulate the cell label and solve my problem:
=($A1+2rows) or some kind of
=$(A+3)$(4+2) that would return cell
Is something like that possible?