Forum Discussion
I want to convert data from horizontal rows to vertical rows
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
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)