Merge multiple fields having different column names and take care of nulls

[monish_chandra]

I have two data sets

> Survey results

>Master data

These two data sets have different field names. I'm trying to Union the field names by manually configuring the positions. But it doesn't take care of the nulls. There are around 50 fields. How do I get the desired result as shown below.

eg:

Master Data

Application Name	Field_1	Field_2	Field_3
Shoes	Nike		Reebok

Survey Results

App Name	F11	F29	F35
Shoes		Adidas	Under Armour

Desired Output

Application Name	Field_1	Field_2	Field_3
Shoes	Nike	Adidas	Under Armour

[JosephSerpis · Accepted solution]

Hi @monish_chandra if you use a transpose tool to change the data into a vertical format you can filter out the nulls then use a crosstab to return to a horizontal format.