Is there an easy way to transform data after union?

[alexlat11]

Hi,

A common problem I have is if I union data from multiple souces where each data set only has one piece of data in it, there are a lot of null values. Is there an easier way to transform the data all to the first row that doesn't use the multirow formula?  Here is an example of data that I want everything on the first row.

[Luke_C · Accepted solution]

Hi @alexlat11 

Definitely, there was another post earlier that does exactly this. Take a look at some of the solutions and they should work perfectly for you:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Record-display/td-p/894898

Alternatively, if there's truly only 1 piece of data in each source, try using the join tools 'join by record position' configuration.