Forum Discussion
Solved
Combining 2 rows into 1 row and deleting a 3rd row
What I am looking to achieve is to join row 2 onto the end of row 1 and delete row 3, then duplicate this through the worksheet. The data format does not change throughout Any ideas on...
DIverkeith If the number of fields to be returned for each output row is always six (6) you can simply use WRAPROWS/TOROW as follows:
=WRAPROWS(TOROW(A1:D11, 1), 6)Setting the [ignore] parameter to 1 for TOROW will ignore the blank cells automatically.
WRAPROWS/TOROW Results
Does this do what you want?
=LET(c, TOCOL(A1:D1000), f, FILTER(c, c<>0), WRAPROWS(f, 6))
Thank you, this returns what I am trying to do.
