Combine of column [Solved]

Ask a question Deepak Upreti - Latest answer on Mar 10, 2016 10:57AM
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 
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,
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
TrowaD 1999Posts Sunday September 12, 2010Registration date ModeratorStatus October 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,
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!