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
(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 number
A 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)
