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.
Hey guys, wondering if you would have any ideas as to a method to turn my data that looks like Table 1 into an end result in Table 2. Basically for each row I only want one set of names, getting rid of duplicates and NULLS from the other four columns. However I'm not sure how to do this as the two names could be anywhere in those first 6 columns. (There will always be a full name grouped together by the number eg. if Name3 is present, so will LastName3)
Name1 Last Name1 Name2 LastName2 Name3 LastName3 Value