Excel Challenge

[abdullah.alduhaishi]

Hi All,

Your kind support appreciated with below Excel case...

How to copy a raw [put in mind the row is formula and not a value] and paste it in another sheet as a column ?

Since it's a formula it won't work.

 Thanks in advance :)

[#2]

Abdullah,

No matter if the content of the row is formulas or values!

Follow these steps:

• Select the row and copy it.
• Go to another location and press Ctrl+Alt+V to open the paste special dialog box.
• Select Transpose and hit OK.

[#3]

Thanks Haytham for your feedback

I wish it's that easy, Please check below snapshots for more information.

 

In column D all cells are a formula ='Abdullah'!B27

When I copy them to paste in another sheet [with the same steps you shared] it won't work as they are a formula, Please check below.

Hope it's clear now :)

Thanks,

[#4]

Thanks Haytham for your feedback :)

I wish it's that simple, please check below snapshot's for better understanding.

In column D, all cells are a formula [='GSM GAP'!G63], If I implement your shared steps the result won't appear, Please check below snapshot.

Hope it's clear now.

Thanks again for your help :)

[#5]

I didn't know that the cells you have in column D are cell references!

In this case, you have two choices to choose one of them:

#1 Get rid of the formulas and paste them as values by just choosing Values option in addition to Transpose as the below screenshot:

#2 Before you apply the steps in the previous answer, do change the cell references in column D as follows:

Replace this: 

='GSM GAP'!G63

With this:

='GSM GAP'!$G63

Apply this change to all cells in column D, and then copy and paste into another location by following the steps in the previous answer.

[#6]

Dear Haytham,
BIG thanks from the hart,

The first solution didn't work, so I used the second.

2# didn't work but it gave me another way to do my task, so thanks a lot for your kind support.

Best Regards,,,,