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
7 Replies
(Kind reminder 🙂 From Welcome to your Excel discussion space!:
- Device and OS platform, e.g., PC/Windows 10 or Mac/macOS Big Sur 11.2.1
- Excel product name and version numberA Power Query solution attached:
- Hi, Can you please tell me the procedure or the formula used here to achieve this? I have at least 10,000 data
Afraid to say that 10,000 data is very confusing
- Is this 10,000 rows * n pairs of columns (same date in 2 columns then "page views" & "visitors" below)?
Or, something else? in which case it's better you upload another workbook that reflect your actual setup
- It's not realistic to explain each and every Power Query step. So, if you upload a workbook reflecting your actual setup (not 10,000 rows please) I'll be glad adjusting the query (assuming it's doable) and the only things you'll have to do:- Copy/paste all your values in the grey table
- Right-click > Refresh in the green table (output of the query)
Transpose!
Copy values -> right click -> paste contents -> check mark for transpose
Hope I could helpNikolino
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.
