I have a spreadsheet that has 7 columns. column 1 = acct columns 2 - 7 (any one of 6 types of transactions with amount of transaction)
the columns are not organized by any logic. they all contain transactions associated by the account identified in column a with a keyword
I need the row data to stay consistent but add columns that have the transactions organized by keyword in new, properly identified columns
this seems pretty hard but an example of the spreadsheet is posted.
The actual spreadsheet I am working with has thousands of rows.