Forum Discussion
Display Multiple Columns Embedded within each Record
Hello, My raw data example is below and it includes 2 columns (temperature and duration) that require 3 values embedded within each record that match to each other within every single record (eac...
Yes Fowmy , I understand that. However, this doesn't achieve what I'm looking for. The reason each product/country only appears once is because it is merged and centered in Excel. I provided this screenshot as an ideal visual scenario. It applies to each of the 3 rows.
I don't want the other rows such as country and product to repeat 3 times in the visual, this is what I am trying to avoid as it's a lot of data duplication.
Thanks
Anonymous
If you need to achieve what you have in the screenshot then it's possible but the numbers will be converted to text, meaning. is that alright?