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 am looking for solution to make the attached current dataset to be looks like the screenshot below, By create a new columns for each Value and each column Values to be either Yes or No or NA or blank based on the current value in the current dataset.
Try using the attached workflow. I made this with the assumption that the question attachments are always followed by their answer attachments, so all the 'questions' will be odd attachment numbers and all the 'answers' will be even. I use this odd/even trait in the workflow to help with grouping.