Forum Discussion
Append portion of even number rows to odd number rows
Below are a few sample rows from an Excel 2019 file, created from a .CSV file. The Excel file contains records of the loan payment transactions for an auto loan. Each payment transaction takes up...
Excel 365 has functionality that enables solutions which are not remotely similar to those of the traditional spreadsheet. Due to the regulatity of your input data, the formula
= LET(
hdr, {"Date","Principal","Interest"},
amt, WRAPROWS(amount, 2),
dt, TAKE(WRAPROWS(date, 2),,1),
VSTACK(hdr, HSTACK(dt, amt))
)
will generate the output table
A couple of extra statements and it would generate the running balance and stack that as part of the output table.
Whilst I think of it, removing the background white fill will cause the grid to show. Then again View and uncheck 'Grid' would also provide consistency.