Report

Combine of column [Solved]

Ask a question Deepak Upreti - Last answered on Mar 10, 2016 10:57AM
Hello,

How can we show value of more than two column in a single column but in two rows.

please reply at the urgent.
See more 
Helpful
+0
moins plus
Hi Deepak,

That looks like you want to use the transpose option in the Paste Special menu.

For example:
Copy A1:B1, then right-click A2 and select paste special. Mark the transpose option and the data will now also be in A2:A3.

Best regards,
Trowa
Deepak- Mar 9, 2016 04:01AM
Thanks, it is working and I also wanted to know which is the best institute for Advance Excel

waiting for your quick reply
Reply
TrowaD 2033Posts Sunday September 12, 2010Registration date ModeratorStatus December 6, 2016 Last seen - Mar 10, 2016 10:57AM
Hi Deepak,

Try using google searches and when you get stuck, then post your question here.

Best regards,
Trowa
Reply
Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!