How to change the structure of table

yosukewatanabe

Hi, In a relation to this, I could get the data in row range.

After this, I had set the transpose tool. How do I change the structure of table from 1 table?

What I'd like to do is following.

the original data

Field1	Field2	Field3
ID	F3	M0001
ID	F4	M0002
ID	F5	M0003
ID	F6	M0004
ID	F7	M0005
ID	F8	M0006
ID	F9	M0007
Name	F3	machine1
Name	F4	machine2
Name	F5	machine3
Name	F6	machine4
Name	F7	machine5
Name	F8	machine6
Name	F9	machine7

goal

ID	Name
M0001	machine1
M0002	machine2
M0003	machine3
M0004	machine4
M0005	machine5
M0006	machine6
M0007	machine7

JoeM

@yosukewatanabe

You were close! I used the crosstab tool to help get to your goal data. There you can choose what field should be your header (field 1), what field should be the data (field 3), and how to group this data (Field 3). After crosstab, I deselected field 3 to get to your required result.

solution.yxmd