Forum Discussion
Change Column Only, Not Row upon Copy Paste
I'm hoping this community can give me a hand. I need to copy a formula 49 times. However, the column needs to incrementally change while the row does not change. When I copy and paste, the column st...
Usually copy/fill is simply a cheap and cheerful way of scanning the terms of an array/list without any formal recognition that such data structures exist. If you can build the output table as an array, e.g.
= joe+david+Wataru+spectrumLab+brad
where the defined names apply to rows of the data sheets, and could be the result of XLOOKUPs, then a simple TRANSPOSE,
= TRANSPOSE(joe+david+Wataru+spectrumLab+brad)
will switch the rows to columns in the output table, without needing to resort to black magic.
PeterBartholomew1 Thank you for the reply. I certainly did not realize changing columns only when pasting was such an advanced function. I appreciate your suggestions; however, I resorted to changing the columns manually.