Forum Discussion
Solved
Split/merge column into one
| 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 |
Hello pigsinblankets ,
you need to split the columns then to pivot the table.
check this out https://youtu.be/URAJ_aDiREE?si=bCCeW_-bmMMcdsj7
1 Reply
Hello pigsinblankets ,
you need to split the columns then to pivot the table.
check this out https://youtu.be/URAJ_aDiREE?si=bCCeW_-bmMMcdsj7