5

We have several questions about passing data from a double entry table to a simple table shape.

By double entry table I'm referring to something like this

Item January February March
Chair 20 15 18
Vase 7 5 9

By simple table I'm referring to something like this

Item Month Qty
Chair January 20
Chair February 15
Chair March 18
Vase January 7
Vase February 5
Vase March 8

There are other posts about the same "task" that neither unpivot or flatten were included. Below some examples:

I'm wondering if we should make a mini-retag project starting by adding a tag excerpt to and / or select some questions as canonical.

Comments, thoughts, suggestions or concerns?

Related

0

Regarding the basic case having one column for n row headers, one row for m column headers and n by m values it's very likely that the best will be to have a canonical question. Some questions that belongs to this case, from older to newer:

I'm still not sure what existing question should be used as a canonical question. Suggestions?


Case having two column headers OR two row headers (with no blank / merged cells). Some questions that belong to this case:

Case having tow column headers OR two row headers with blank / merged cells. Some question that belong to this case:

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .