Combining Selected Rows to form extended rows

Michael_Lambaskis

Dear All,

I would like your help with a task that should be easy with the multi-row formula tool, but I didn't manage to succesfully perform it.

From the list of the rows on my table, I would like to select specific rows and and add them next to the above rows (extent the above row to have more columns).

My first column looks like this:

1   Nuevo
2   CM1123456789

3   Rostert
4   XH1233456789

So, I would like to select the first column, and choose that all rows that contain [A-Z0-9]{12} such as rows 2 and 4 below, be transposed to extend the previous row.

Hope it makes sense.

Thank you.

danilang

Hi @Michael_Lambaskis 

Is it always "all the fields from Row N+1 to Row N" or are there any other special conditions that you need to consider?  If it's always N+1 tacked on to the N rows you can use this

Add a RecordID.  Split the data set into even and odd records and join on record position, giving

Dan

Extend.yxmd