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 |
Solved! Go to 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.