Split/merge column into one

[pigsinblankets]

Table 1
Project	Variable
1	1, 2, 3
2	4, 5, 6

 Good morning 🙂 - I'm trying to change table 1 shown above into table 2, I've tried splitting by the comma delimiter and merging columns but am struggling to get this to work - what is the simplest way to be able to split the variables to be able to get the table 2 output? 

Thank you! 

Table 2
Project	Variable
1	1
1	2
1	3
2	4
2	5
2	6

[Idrissshatila · Accepted solution]

Hello @pigsinblankets ,

you need to split the columns then to pivot the table.

check this out https://youtu.be/URAJ_aDiREE?si=bCCeW_-bmMMcdsj7