Forum Discussion
create a raw data for production
Hi
Can you explain this in more detail - perhaps with an example?
I assume you have data from an external system and you want to import in into Excel so you can analyse it? Is that correct?
Providing a better explanation will help move this forward.
regards,
Peter
yes, It is external data that is received daily
Kindly find the below example as the header of the data that I need to analyze.
Hi
I can see your headers which seem OK - I do not understand what your problem is? Why don't you populate the spreadsheet from your external data?
Please clarify?
Peter
Ok,as you know, if I will do a pivot table or converted it to a table, this is impossible due to having two headers. Meaning even when I create a chart per the product to analyze the daily production of it, I need to convert the data to another shape which is hard if my table is not an official table in excel or a pivot, especially that the data is increasing in a daily basis.
Hope you understand my point of view
