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 attached some sample data of the formatting of the original data and the desired output. To start, I tried to get to the desired output by just using the Username and email, and was able to do so via the attached workflow. However, not having any luck on figuring out how to apply to the rest of the data. Any ideas?
Whenever I have data in a single workbook that is shaped differently I follow a process like this:
Group the rows into record numbers. In your case, that means finding a way to group every row associated with User name AB123 into a single record number, and every row associated with user name CD456 into a different record number.
Separate the differently shaped data into two different sets
Get both sets of data into the same shape
Blend back together
I attached an example here - let me know if this works for you!