Combine of column

Solved/Closed
Deepak Upreti - Mar 7, 2016 at 02:20 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 10, 2016 at 10:57 AM
Hello,

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

please reply at the urgent.

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Mar 8, 2016 at 11:03 AM
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
Thanks, it is working and I also wanted to know which is the best institute for Advance Excel

waiting for your quick reply
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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,
Trowa