If it's not a one time chore you could look into writing a spreadsheet macro to do it for your each time.
Regards, Geert Op zondag 1 november 2020 06:42:19 CET schreef [email protected]: > Is this a one time chore. I don't know about doing it on the Gnucash side, > but it seems relatively easy to do in in a spreadsheet. > > Insert a column for numbering the rows. > > Duplicate all the rows as a block, i.e. with the second copy of all the rows > following the first block e.g. > 1 a ... > 2 b ... > 3 c ... > 4 d ... > 1 a ... > 2 b ... > 3 c ... > 4 d ... > > In the first block clear the column for one of the splits > In the second block clear the column for the other split > > In one block copy the splits into the same column they are in in the other > block > > Finally sort all rows to put the splits back on consecutive rows > 1 a ... > 1 a ... > 2 b ... > 2 b ... > 3 c ... > 3 c ... > 4 d ... > 4 d ... > > Will > > > > On 2020 Oct 31, at 10-31 19:21:14, Craig Phillips <[email protected]> > wrote: > > Hi, > > I've been scratching my head on how to do this for a significant time so > hoping someone can help... > > I have transactions that I have downloaded from a site, and that I would > like to import into gnucash using a csv. > > Each transaction is a row and in columns I have a total credit, balanced by > the sum of two debits. > > Normally when I'm trying to work out what my import file needs to look like > I enter an example transaction manually and then download the transaction > list from that sub account to give me an idea of what I would need to do. > Having done that, and what I can gather from the documentation, it looks > like split transaction entries are meant to be entered as rows one after > the other. This would be painful for me as I have the necessary data in > columns and I can't work out an easy way of transposing the data to > individual rows. > > So my question - can the csv import work for me if I'm looking to upload > one row for a split transaction? (i.e. one credit balanced by two debits). > If so, what does it look like? > > Thanks in advance for your help. > _______________________________________________ > gnucash-user mailing list > [email protected] > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > > _______________________________________________ > gnucash-user mailing list > [email protected] > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. _______________________________________________ gnucash-user mailing list [email protected] To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
