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.
Uses the formula tool with IF statements to create the three columns after they've been transposed.
One of the first times I have used the make columns tool...
Needed help on this one. Thank you for the many different solutions. Went the popular route.
Pretty similar just ended with data cleansing rather than using formula to trim before.
uploading the solution.
Follow my solution file attached...
Here's how I solved this this :)