Duplicate data

[ktt777]

Hi 

i have a table like this

And a list of country :

How can i duplicate data for France, Japan, China to have the same data as Germany & USA ( 2 processes ordering & receiving with the same time value )?

thank you

[FarhanAhmed · Accepted solution]

Considering that your Year/PR/Process/Time is consistent for every country. Now you can do following

- Remove country from the main data table

- Remove Duplicate Rows

- Add CountryList Table as your custom Column

Expand the column that will give you Values.

Regards

[v-xiaotang · Accepted solution]

Hi @ktt777 

Based on your sample data,

firstly, create a table containing Process & Time

TableTest1 = SUMMARIZE(Table1,Table1[Process],Table1[Time])

then, build the combination table

Table = CROSSJOIN(Table2,TableTest1)

result

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[FarhanAhmed · Accepted solution]

Considering that your Year/PR/Process/Time is consistent for every country. Now you can do following

- Remove country from the main data table

- Remove Duplicate Rows

- Add CountryList Table as your custom Column

Expand the column that will give you Values.

Regards