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
0
Thanks, it is working and I also wanted to know which is the best institute for Advance Excel

waiting for your quick reply
0
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
0