Combining Multiple Data Tables by Column

[tktmastr]

Hi!

This seems like it should be simple, but I've spent a couple of hours trying to figure it out 😞

I have a main data table from an API, called Events. Each event has a separate table with price points.

I would like to have one data visualization table that shows a row for each event, and the applicable prices. I've tried transposing, joins, pivots, etc. but nothing is giving me the desired result. 

See image below.

Just looking for a point in the right direction, thanks!

[Ashish_Mathur]

Hi,

Share data in a format that can be pasted in an MS Excel file.

[tktmastr]

Hi,

Here's a link to the Excel file with data tables: data_example.xlsx

Thanks

[Ashish_Mathur · Accepted solution]

Hi,

Append data from Table 2,3 and 4.  Merge data from this apended table into Table 1.  In the Merged Table, click on any cell in the Level.name column and click on Pivot.  Select the function as "Do not aggregate"

[tktmastr]

Worked perfectly, thanks!