Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
This is super important for me right now and highly appreciate if someone can help me achieve the following.
I am looking to trim the last part of column values ("_x,""_y,""_z" ) and add it to rows and make the table looks like the following.
Can someone please assist me to get this
Your comma separated value file has no commas...
Thanks for the heads up,
Check Again its an excel file now
The answer is to use crosstable individually and then combining the cross tables with RIGHT() function.
Let me know if anyone has question :