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.
If you transpose the data, then filter out the Null() records (Can use something more encompassing like !IsEmpty(TRIM([Value])) in order to get empties as well). Then you can use the Unique Tool on the Name field to take the first value of each.