Report

Combine of column [Solved]

Ask a question Deepak Upreti - Latest answer 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 1988Posts Sunday September 12, 2010Registration date ModeratorStatus September 19, 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

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!