**Question description:**

*This user has given permission to use the problem statement for this
blog.*

I need to paste date from a column in one sheet and paste it in a row in another sheet. The cells have formulas. Copying then transposing is not working. Please help

Solved by O. E. in 40 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

Excelchat Expert
31/07/2018 - 07:59

Hi

User
31/07/2018 - 07:59

Hi

User
31/07/2018 - 08:00

I need help with the issue mentioned above

User
31/07/2018 - 08:00

I need to paste date from a column in one sheet and paste it in a row in another sheet. The cells have formulas. Copying then transposing is not working. Please help

Excelchat Expert
31/07/2018 - 08:00

Correct me if I am wrong, so you want to paste column in another column but the issue you are facing is due to formulas being present

Excelchat Expert
31/07/2018 - 08:01

Can you follow me step by step I will guide you to through it?

User
31/07/2018 - 08:01

I want to copy cells from a column and paste them in a row in another sheet

Excelchat Expert
31/07/2018 - 08:01

Sure

User
31/07/2018 - 08:01

The cells have formulas

Excelchat Expert
31/07/2018 - 08:01

Select the contents of the column

Excelchat Expert
31/07/2018 - 08:02

Let us say they are present in A1 to A10

Excelchat Expert
31/07/2018 - 08:02

then select A1 to A10

User
31/07/2018 - 08:02

ok

Excelchat Expert
31/07/2018 - 08:03

Step 2. Ctrl + C to copy the cells

User
31/07/2018 - 08:03

ok

Excelchat Expert
31/07/2018 - 08:03

Step 3:Go to the the cell from where you want to paste the column as row

Excelchat Expert
31/07/2018 - 08:04

Step 4: Press Alt then E then S then V then E and then Enter

Excelchat Expert
31/07/2018 - 08:04

(Do not press together)

User
31/07/2018 - 08:05

ok

Excelchat Expert
31/07/2018 - 08:05

By now it should have been pasted

User
31/07/2018 - 08:05

I got a window

User
31/07/2018 - 08:05

paste special

Excelchat Expert
31/07/2018 - 08:06

Yes, make sure Values and Transpose are selected

Excelchat Expert
31/07/2018 - 08:06

and then click on OK

User
31/07/2018 - 08:07

it only pasted some of the values

User
31/07/2018 - 08:07

strange

User
31/07/2018 - 08:07

it skipped 3 values

Excelchat Expert
31/07/2018 - 08:07

Did the paste area had sufficient space?

Excelchat Expert
31/07/2018 - 08:07

Can you share your eheet?

User
31/07/2018 - 08:08

its confidential.. sorry

User
31/07/2018 - 08:08

it did yes

Excelchat Expert
31/07/2018 - 08:08

ok. Can you tell the Cell numbers where your data is present?

User
31/07/2018 - 08:09

U172

User
31/07/2018 - 08:09

till U179

Excelchat Expert
31/07/2018 - 08:09

and where do you want to paste it?

User
31/07/2018 - 08:09

I want to paste them on another sheet at C43 till O43

User
31/07/2018 - 08:10

Oh I completely forgot I had hidden columns in the new sheets

Excelchat Expert
31/07/2018 - 08:10

U172 to U179 are 8 values while C43 to O43 are 13

Excelchat Expert
31/07/2018 - 08:11

I think it will work now since you know about hidden columns

Excelchat Expert
31/07/2018 - 08:11

:)

User
31/07/2018 - 08:11

Awesome

Excelchat Expert
31/07/2018 - 08:11

I hope I was able to help

User
31/07/2018 - 08:11

now how do I drag this

User
31/07/2018 - 08:11

to the rest of the rows

Excelchat Expert
31/07/2018 - 08:11

Hey, sorry to break it to you but only one question per session :(

User
31/07/2018 - 08:12

this is realted to my question

User
31/07/2018 - 08:12

please I need this

Excelchat Expert
31/07/2018 - 08:12

And as your description mentioned about the copy paste I will not be able to help you with the other question

Excelchat Expert
31/07/2018 - 08:13

I can provide hint that you will have to change your formula referencing from absolute to relative

User
31/07/2018 - 08:13

when the window pops up?

Excelchat Expert
31/07/2018 - 08:13

No, in the formula of the cells

User
31/07/2018 - 08:13

the cells i want to copy

User
31/07/2018 - 08:14

or paste into?

Excelchat Expert
31/07/2018 - 08:14

And for drag-drop you will have to share your excel else no one will be able to help

Excelchat Expert
31/07/2018 - 08:14

simple idea is to first drag when they are column to as many rows are you need and then transpose it

User
31/07/2018 - 08:15

I am completely lost here

User
31/07/2018 - 08:15

sorry

User
31/07/2018 - 08:16

plz help

Excelchat Expert
31/07/2018 - 08:17

Sure

Excelchat Expert
31/07/2018 - 08:17

But I will need spreadsheet

Excelchat Expert
31/07/2018 - 08:17

without which I will not be able to help within the allocated time :(

User
31/07/2018 - 08:18

ALTESVE did not paste formulas

Excelchat Expert
31/07/2018 - 08:19

To paste formulas you will have to do Alt E S F E

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user
information.*