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 need help to convert horizontal data to vertical. currently i have the some headers are the same values and when i tried to do a compose and cross tool it group the headers together. so here are the data and i want it to look like this. I need help.
yes i tried your method. all i want to do is flipping the entire data to vertical so i can do a dynamic select after that base on the Name. the reason i used a sample tool its because there are data in the first 4 rows i dont need to be included.
After looking at your image more closely I see what is happening. The Crosstab tool sorts the rows alphabetically. This isn't a problem if you have less than 10 rows but with more than that you have the order F1, F10, F2, F3, etc, since F10 comes before F2 alphabetically. This new version builds a row number field and uses that to order the rows. You shouldn't have any skipped rows now.