Excel copy/paste formula issue

[killerthun]

Hello.

There are 2 sheets.
Sheet 1 has data going down.
Sheet 2 has data going across.

I included an example spreadsheet: Example.xlsx
Sheet 2 is pulling data from sheet 1.
When I copy/paste the formula ( =!Sheet1B2 ) into the next cell, it increases by cell value, and I need it to increase by Row value.

[vorabha]

you can use instead of formula
Copy your main data > Paste special > transpose

may be this helps


Vorabha

[killerthun]

I need to be able to use formulas, but thanks