Forum Discussion
Transpose the value
I don't see/understand the rounding issue you refer to. Instead of sharing video or Word doc. could you please:
- Use your actual data
- Refresh the query I shared
- Highlight any rounding issue in the resulting table
and then share the Excel file
Something less painful than formulas with Excel 2016, Get & Transform aka Power Query
In attached file:
#1 Put your data in 'Table1'
#2 Switch to tab 'Power Query'
#3 Right-click in the green table > Refresh
one of the issue is faced is that rounding error of the value.
I don't see/understand the rounding issue you refer to. Instead of sharing video or Word doc. could you please:
- Use your actual data
- Refresh the query I shared
- Highlight any rounding issue in the resulting table
and then share the Excel file
I am first time use the power query. Just a few links:
- https://support.microsoft.com/en-us/office/getting-started-with-get-transform-in-excel-a8310388-2a12-438c-9d29-c6d29cb8df6a
- https://support.office.com/en-us/article/guide-to-the-power-query-ribbon-05044d36-5261-4219-8324-83adffa27249?ui=en-US&rs=en-US&ad=US
- https://support.microsoft.com/en-us/office/view-and-manage-queries-in-a-workbook-power-query-76f93a6d-37d9-46b5-bc40-d5f2162401f5
- https://support.office.com/en-us/article/microsoft-power-query-for-excel-help-2b433a85-ddfb-420b-9cda-fe0e60b82a94#__tutorials
- https://support.microsoft.com/en-us/office/power-query-101-008b3f46-5b14-4f8b-9a07-d3da689091b5
- https://support.microsoft.com/en-us/office/modify-a-formula-power-query-87c27c8e-1693-476d-8c4e-a83578f66d25
- https://support.microsoft.com/en-us/office/edit-query-step-settings-power-query-3e221afc-c764-4cd9-9a96-a5a5a7688e46
- https://docs.microsoft.com/en-us/powerquery-m/
- https://www.youtube.com/watch?v=NS1AvfV9BeI
What exactly is your question?
