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.
This was a fun one because what you appear to be doing is shifting the column values up to replace null values, so your output row 1 is composed of Name from input row 2 and City and Date from input row 1. An interesting technique I've never come across before.
The workflow transposes the input data and remove the nulls. It then builds new output row number and crosstabs to get a new data set. The new set can have empty values in the last set of rows, so you transpose it and count the number of empty values per row and pass on the rows that have all values filled. Use a filter to remove the rows from the new data set and you're left with
Note that you actually have enough data to make 3 complete new output rows as opposed to the 2 that you have in your sample