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, 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)