0

Monthly Balances In Vertical Format

I have managed to pull the monthly trial balance into Excel via Jet in the normal table format, ie. with headers as follows:

Account No, Account Name, Account Type, Month 1, Month 2, Month 3 …. etc

However for other reasons, I would like to get the data in the following format - any ideas please as I am new to Jet:

Account No - Accounts Name - Account Type - Month - Balance
01000 - Account 1 - Posting - Month 1 - £xxx
01000 - Account 1 - Posting - Month 2 - £xxx
01000 - Account 1 - Posting - Month 3 - £xxx

etc

Thanks

1 comment

Please sign in to leave a comment.