How to split the data and write in another data table?

Hi Team,
Please try to help on this.

partNumber quantity issueId
A 5 1#7
B 6 2#8#9
A 8 3#10
C 9 4#35#45#2
D 10 5#8
E 15 69#5#6#8#10
F 18 723#52
B 19 8#32

i need to split based on “#” delimiter

I Want output like this.

partNumber quantity issueId issueId2 issueId3 issueId4 issueId5
A 5 1 7
B 6 2 8 9
A 8 3 10
C 9 4 35 45 2
D 10 5 8
E 15 69 5 6 8 10
F 18 723 52
B 19 8 32

Thank you.

You can try this

yourArray = String.Split("#"c)

Hi @Ranjith1996
Please find attached solution Transactions.xlsx (9.0 KB)
distinctrows.xaml (35.8 KB)

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.