Split single row into multiple rows

[mahanthesha]

Hi Team,

We have requirement to split single row into multiple rows based on specific column value.
Attached screenshot provides you the pictorial explanation.
If discount price column value is not empty then split into multiple rows.

Let me know if you need more details.

Thanks,
Mahantesh

[dgudkov]

Hi Mahantesh,

It looks like you need to make two rows from two columns. This can be done with the “Unpivot action”. See the example below.

unpivot.morph (3.4 KB)