Split excel cell into different rows in GUI

Question

I have an excel file which contains something like this:

I have a running python script which creates a User GUI. The GUI lists the "Description" column from the excel as a single line in the GUI. I would like to have new lines after each semicolon ";" in the Description. i.e

Current output:

Expected output:

Expected output 2

Do you want separate line in same cell or each line in each cell? — Harun24hr, Jan 26 '22 at 12:23
If you are looking for help in Python, I think you should add the proper tag and the code. — Foxfire And Burns And Burns, Jan 26 '22 at 12:25

score 0 · Answer 1 · answered Jan 26 '22 at 12:28

0

You may try FILTERXML()

=FILTERXML("<t><s>"&SUBSTITUTE(A1,";","</s><s>")&"</s></t>","//s")

More about FILTERXML()

answered Jan 26 '22 at 12:28

Harun24hr

30,391
4
21
36

Hi Harun, i guess this is not what i want. I dont want the seperated result in Excel but in the GUI. – matt Jan 27 '22 at 15:51

Split excel cell into different rows in GUI

1 Answers1