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'm Having the Data as below,
And So on...
I need to split this "Category" column into Two Columns "Category1"and "Category2" .
Can Somebody help on this please?. After splitting into two I need to left join both the output(which I'm aware).
Cross tab is tool to go too when you want to make rows into column headers:
Any questions or issues please ask :)HTH!Ira
@kiotsuresh One way of doing this
I have Data like this,
and so on. will this solution work in this case?
@kiotsuresh Does the extra spaces mean its a second name?
@kiotsuresh updated the workflow
Have Updated my Query
I have Updated the Post Sir.
Heres one way to do that:
@kiotsuresh one way of doing this