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 have attached an example of what I am trying to achieve with my data set. I want to take the data within a column and make them all into columns, and I also want to make the data within another column, rows.
Thanks, that worked great, but I have a problem. The data I want to make columns, contain duplicates. I want to get rid of the duplicates and only display the value once in the column. I used a summarize tool and grouped Manufacturer, but it only displays that column so I can't connect it to the crosstab tool. Do you know how I could have it so the manufacturer grouped by column stays along with the name column so I can use the crosstab tool?
Yes that worked. Thanks. However, I am noticing that my columns are duplicated. So for example: I will have column abc and then First_abc and then def and First_def. Do you know why that is and how to get rid of those columns
Hey, I just found another problem. Because I got rid of the duplicate columns using the unique tool, it only shows one value under each column. A lot of these columns have duplicate names. For example: manufacturer 123 has abc as name but it also has fbp and qct. How do I make it so that all of these names show up under the column 123 because right now the only name under that column is abc.