Forum Discussion
create a raw data for production
Good afternoon, I hope everyone in good health. I am seeking support to create a new database for a production line, where the data is received daily which are the production source, amount...
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
Hi
Why don't you change your format to a excel table as shown in the attached? That way you can create charts etc.
Is this not what you want?