https://community.qlik.com/t5/QlikView/Transpose-a-Comma-Separated-Field/m-p/1588621#M739078 <P>&nbsp;</P><P>Got it...</P><P>SubField(UserID,',')</P> Wed, 05 Jun 2019 13:43:35 GMT haymarketpaul 2019-06-05T13:43:35Z https://community.qlik.com/t5/QlikView/Transpose-a-Comma-Separated-Field/m-p/1588614#M739077 <P>&nbsp;</P><P>I have a field with comma separated numbers that I just need to turn into a column of single numbers - How to transpose in the script?</P><P>eg&nbsp; Field of UserIDs</P><TABLE border="1"><TBODY><TR><TD>12345,23456</TD></TR><TR><TD>34567,45678,56789,67890,54321</TD></TR><TR><TD>82736</TD></TR><TR><TD>65432,11223,22334</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Would become field with the following:-</P><P>12345</P><P>23456</P><P>34567</P><P>45678</P><P>56789</P><P>67890</P><P>54321</P><P>82736</P><P>65432</P><P>11223</P><P>22334</P> Sat, 16 Nov 2024 20:43:22 GMT https://community.qlik.com/t5/QlikView/Transpose-a-Comma-Separated-Field/m-p/1588614#M739077 haymarketpaul 2024-11-16T20:43:22Z https://community.qlik.com/t5/QlikView/Transpose-a-Comma-Separated-Field/m-p/1588621#M739078 <P>&nbsp;</P><P>Got it...</P><P>SubField(UserID,',')</P> Wed, 05 Jun 2019 13:43:35 GMT https://community.qlik.com/t5/QlikView/Transpose-a-Comma-Separated-Field/m-p/1588621#M739078 haymarketpaul 2019-06-05T13:43:35Z