Combine multiple columns into one

[jagstirling]

Simple question (I doubt the solution is as simple).

QUESTION : Is it possible to do turn data structured like this;

Into this;

[comment]

Import the source data 3 times. The first time, import the first three columns into their corresponding fields of the target table and FIELD1 into FIELD99. For the second import, keep the same mapping except this time map FIELD2 into FIELD99. The third time, import FIELD3 into FIELD99 - again, together with the first three columns.

 

Edited May 7, 2016 by comment

[jagstirling]

Thanks, the data is already in Filemaker, so I don't need to import

I want to get the 3 fields into 1 filed so I can chart them

[comment]

Whoa, we need to regroup here.

First, "data structure" is defined by tables and fields. When you are talking about "changing the data structure", you are perforce talking about moving the tenant data to a new schema to house it.

Next, the original data structure that you show us is not normalized. We don't know what this data represents, but in order to process it you will very likely benefit by restructuring it to its normalized form. Note that your second structure is not fully normalized either.

Finally, if your question is about charting the existing data, then ask about that - and explain what exactly the chart should show. I would also suggest using meaningful names instead of a completely abstract example - it makes it much easier to understand the situation.

 

21 minutes ago, jagstirling said:

I want to get the 3 fields into 1 filed

Not exactly; you also want to get three records for each existing record.

 

Edited May 7, 2016 by comment

[jagstirling]

Field 1, Field 2 and Field 3 are months.

I would like to place them in a Stacked Column chart which I cannot do if they are in three different columns.

[comment]

I am afraid that's not clear at all.

[bruceR]

Certainly agreed there. Additionally; what are columns A,B, C?