Reformatting data to facilitate union

[datadriven1]

Hello,

I have two datasets that require union of different formats.  I would like assistance reformatting Dataset #2 to be able to Union with Dataset #1. I've included screenshots below as to what I suppose is the best way to transform the data yet I can't figure out how.

Dataset #1 Format

Dataset #2 Format

Supposed best transform output for being able to union Dataset #1 & #2:

Post Union:

[fmvizcaino · Accepted solution]

Hi @datadriven1 ,

Attached is an example showing how to do the transformation.

Please mark the answer as correct if this is what you are looking for 🙂

Best,

Fernando Vizcaino

[datadriven1]

I might have just figured out how to make this work using the Transpose* function