Combine of column

[Solved/Closed]
Report
-
Posts
2809
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 23, 2021
-
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 reply

Posts
2809
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 23, 2021
483
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
Posts
2809
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 23, 2021
483
Hi Deepak,

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

Best regards,
Trowa