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.