Import vertical information from Sheet1 and export in horizontal inside Sheet2

Hello Guys,

Is there a formula or function to take information from a column in Sheet1 and export to Sheet2 on horizontal in different cells?
Basically i need to fill some horizontal cells inside Sheet2 with information of Sheet1. Ive tried copy paste with tranpose, but it takes a lot of time...
Does anyone have an ideia?

Thank You

It works for one cell only.
if I move the formula the the next cell on horizontal the result will be 0...

How about

Formula:

Please Login or Register  to view this content.

I haven't this formula in my Excel :/ Am i doing something wrong?

Are you trying to do this in Excel 365 or some other version?

Originally Posted by Fluff13

Are you trying to do this in Excel 365 or some other version?

Excel 2019

It would have helped if you had said that at the start as your profile shows you are using 365.
Try

Formula:

Please Login or Register  to view this content.

I have 365 at home and 2019 at the company, that’s why I have 365 in my profile.
That formula works vertically and it’s not what I want.
I want to take information from A1, A2, A3 and etc and paste it at C1, D1, E1 and etc.
Sorry for don’t believe clear at the start.
Thank you Bob

That formula works vertically

No it works horizontally if you put the formula in D1 & drag to the right.

Sorry, i did wrong teste with the formula.
You are sure, it works like a charm
Thank you for the help!

Glad to help & thanks for the feedback.