Forum Discussion
Debasmita23
Jul 01, 2021Copper Contributor
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
Lorenzo
Jul 01, 2021Silver Contributor
(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:
Debasmita23
Jul 01, 2021Copper Contributor
Hi, Can you please tell me the procedure or the formula used here to achieve this? I have at least 10,000 data