Hi everyone
The quarterly Xero VAT report includes the VAT 'type' in the same columns as the individual transaction dates. I would like to 'unpivot' this, in some way, so that I can recreate the VAT return. I was trying to replace the date with null/blank and then fill down but hit a dead end! Any support gratefully received!
Thanks
Casey
Hi Casey,
Can you please supply a file we can work on so we don't have to try reproducing the data.
Regards
Phil
Of course. Thanks Phil.
Hi Casey,
Thanks for sharing the sample file. You can use a conditional column to extract the VAT types from the first column and then copy down. See attached.
Note: I also removed the total rows.
Mynda
Hi
Apologies - I should have looked more closely. It does not resolve the issue since the conditional column is only looking for 'VAT' but there are 7 other 'types' without VAT in the in the type name.
These types may change and the query would need to work for two entities (for each VAT return).
Hope you can help!
Best wishes
Casey
I edited last post - but that might not have been picked up. Apols!
In that case, another way to set the condition is to change the 'contains' VAT to 'does not contain' /
This will get all rows that aren't a date with a forward slash.
Mynda
