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.
@SouravKayal you're essentially looking to get the data in the correct form to cross-tab. You may need to add another step to this in your data, making a tag to group on in the crosstab to stop concatenation.
Edit: Also realised I missed that it looks like you might be talking about a column name. If so then Finn's solution below is perfect
@SouravKayal Finn's answer isn't catching it because there's a space in your real data after the : which would need to be reflected in the RegEx. Mine is looking for the word name instead of Owner. Both should be fairly easy fixes depending on what you're looking for.