Dear All, I have the below table and need to achieve the last 'Sales USA' column CountryCategorySub-CategorySalesSales USAUSAFurnitureBookcases261.96261.96USAOffice SuppliesChairs731.94731.94USATechnologyLabels14.6214.62ChinaFurnitureBookcases1900261.96ChinaOffice SuppliesChairs485731.94ChinaTechnologyLabels35014.62AustraliaFurnitureBookcases445261.96AustraliaOffice SuppliesChairs725731.94AustraliaTechnologyLabels120814.62 As we see here the last column is a copy of the USA data. So for every country in my dataset need to repeat and copy the USA data as a column. The category and Sub category columns are constant for all countries. Do let me know in case of any questions. Thanks

Copy values in a column to each record

Dear All,

I have the below table and need to achieve the last 'Sales USA' column

Country	Category	Sub-Category	Sales	Sales USA
USA	Furniture	Bookcases	261.96	261.96
USA	Office Supplies	Chairs	731.94	731.94
USA	Technology	Labels	14.62	14.62
China	Furniture	Bookcases	1900	261.96
China	Office Supplies	Chairs	485	731.94
China	Technology	Labels	350	14.62
Australia	Furniture	Bookcases	445	261.96
Australia	Office Supplies	Chairs	725	731.94
Australia	Technology	Labels	1208	14.62

As we see here the last column is a copy of the USA data. So for every country in my dataset need to repeat and copy the USA data as a column. The category and Sub category columns are constant for all countries.