Forum Discussion
I want to convert data from horizontal rows to vertical rows
Please find the attachment. I have shown attached excel, that what I am trying to achieve. Please let me know if that is achievable in excel. Thanks
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.
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.