Forum Discussion
I want to convert data from horizontal rows to vertical rows
Transpose!
Copy values -> right click -> paste contents -> check mark for transpose
Hope I could help
Nikolino
I know I don't know anything (Socrates)
Hi Nikolino, Thank you for your reply. I tried that but didn't get my desired output
whereas I need this, I wonder if this is possible in excel or not
- Assume that your knowledge of Array Formulas and Pivot Tables is limited.
As a proposed solution, VBA could be added with a macro running a standard procedure. but that would be standard for all entries.
Otherwise you could do it with formulas, but there would also be different formulas in different cells.
Both take time, which unfortunately I don't have at the moment.
Maybe later, if no other solution is available by then. There are many ways that lead to Rome .... again as many possibilities in Excel to approach a problem, let alone the vast number of suggested solutions that arise from it.
Simplified: Everything is possible with Excel ... if not everything, then most of it :)).Here is a suggested solution with a formula.
Sometimes you need to switch or rotate cells. You can do this by copying, pasting, and using the Transpose option. But doing that creates duplicated data. If you don't want that, you can type a formula instead using the TRANSPOSE function.
Thank you for your understanding and patience
Hope I could help
Nikolino
I know I don't know anything (Socrates)