Hi SaikatSaha,
Copying, pasting, and using the Transpose option are the things you need to do when switching or rotating cells. However, you need to be careful when using these processes because they produce duplicate data. If you want to learn more
about the Transpose function, you can click on this link. Kindly read the whole article to fully
understand the transpose function. If you want to transpose data from rows to columns or the other way around, please check this
link for the detailed instructions.
If you would like me to provide additional advice, simply respond to this thread. I will get notified and I’ll reply to you as soon as I can.
Bob