Pivot Table Help

[RNightscape]

Hi all,

Please I Merged a Table and would like to know if there's a way to distribute the colors by car.

The intention is duplicate the car's line and a single color .

Is it possible?  And How?

[v-frfei-msft · Accepted solution]

Hi @RNightscape,

We can use CROSSJOIN function to merge two tabels as you need.

Table = CROSSJOIN(car,color)

For more details, please check the pbix as attached.

Regards,

Frank

[RNightscape]

Thank you very much by your help! worked very well!