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
Is this a one-off or do you have to do this on a regular basis? Can you perhaps provide an Excel file with some dummy data, but in the current format?