This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I would consider to transpose all the columns and then remove it from the data column. After removing new line chars you can then crosstab the data back to normal. To transpose data you can watch this video.
Your solution looks like it could work for my problem. However, in my multi-formua tool, it is already truncating my data. Please see attached screen shots. Can you let me know where I'm going wrong here please?