RafiSharif
New Member
- Joined
- Apr 3, 2021
- Messages
- 3
- Office Version
- 2016
- Platform
- Windows
- Mobile
- Web
I have a worksheet that has data stored in a report like format.
Sales data with order number & other information but the issue is they are separated by country & the country name is on top of a table like structure & it repeat the same structure only the country name changes every time.
Is there anyway to have all the records in the same structure and removing the total from each country, & add the country names in a new column corresponding to the data.
Sales data with order number & other information but the issue is they are separated by country & the country name is on top of a table like structure & it repeat the same structure only the country name changes every time.
Is there anyway to have all the records in the same structure and removing the total from each country, & add the country names in a new column corresponding to the data.