Combine of column [Solved/Closed]

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

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

please reply at the urgent.
plus moins
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 at 04:01 AM
Thanks, it is working and I also wanted to know which is the best institute for Advance Excel

waiting for your quick reply
TrowaD 2282Posts Sunday September 12, 2010Registration date ModeratorStatus October 19, 2017 Last seen - Mar 10, 2016 at 10:57 AM
Hi Deepak,

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

Best regards,

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!