Can I sort groups of rows in Excel so that the rows remained grouped after being sorted?
use custom sort by two columns - for each transaction add one column with unique number (maybe you already has one) and then sort first by that column and second by your desired column with date
jackerman09
By Day: CPA at Wagner, Ferber, Fine & Ackerman, working primarily with small businesses and their owners. I love working with startups, especially in the tech space, as there aren't too many accountants that can also understand the code their clients are writing. By Night: Rails developer working on my own projects for fun/maybe they'll go somewhere.
Updated on June 04, 2022Comments
-
jackerman09 almost 2 years
I have a list of transactions that I will be importing into Quickbooks, and because of their file format requirements, each transaction takes up 3 rows in Excel. Is it possible to sort the transactions by date (which is in column D of the first and second of the three rows), while keeping the rows grouped by transaction?
Thanks!
-
jackerman09 almost 11 yearsI'm a little confused by your suggestion. Wouldn't sorting by the unique ID then by the date give me a list sorted by ID, and since there are no duplicate ID's, the sorting by date would be irrelevant? Also, it's worth pointing out that the 3rd row of each transaction does not have the date in it, it is all blank except for the first column which indicates the end of the transaction as "ENDTRNS", and this cannot be changed.
-
Ochi almost 11 yearsthe same unique ID for all records of one unique transaction - if something is odd in what I'm saying please add some example structure of your file to your question