Converting Cell value into Rows Cell to rows (for the items which are Pipe separated)

[Rani1 (Rani)]

Here is my input table and I want to generate the output table as shown below. Can someone help me with the logic?

Input:

Output:

[supermanPunch (Arpan)]

Hi @Rani1 ,

Could you Check the below Workflow :
SplitValues_Into_SeparateRows.zip (9.9 KB)

Using the Linq zip method we will be able to combine the values present in two lists/arrays accordingly as per their indices. But in case a value doesn’t exist, a handling is not done by default and hence we have checked the count of the Total values first and then Added the NULL values into the arrays/List where a particular Email doesn’t have it’s respective ID or where the number of items in the array/List was less.

Maybe a better approach would be possible. But let us know your thoughts on this approach.

More on Linq Zip method :

Enumerable.Zip Method (System.Linq)

[RajKumar_DC (RajKumar Durai)]

Hi @Rani1 ,

What about below workflow

Split.xaml (12.0 KB)

TEST.xlsx (9.8 KB)

Thanks,
Rajkumar