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
In your initial post you had 5 columns: [Ledger]...[Credit (VAT)], in the workbook you just shared there's an extra [Column1]:
Not really a suprise you have issue(s)
I give up
If someone else wants to take it over feel free