# Excel - COLUMN Function Problem - Expert Solution

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
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
Excelchat Expert 31/07/2018 - 08:12
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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.