How can I convert a table with horizontal data to a table with vertical data ?
This example illustrates one row (Table 1) of data to many rows of data (Table 2).
Source
Table 1
Name Type Field1 Field2 Field3 Field4 Field5 Field6 Field7
Results
Table 2
Name Field1 Type
Name Field2 Type
Name Field3 Type
Name Field4 Type
Name Field5 Type
Name Field6 Type
Name Field7 Type
This example illustrates one row (Table 1) of data to many rows of data (Table 2).
Source
Table 1
Name Type Field1 Field2 Field3 Field4 Field5 Field6 Field7
Results
Table 2
Name Field1 Type
Name Field2 Type
Name Field3 Type
Name Field4 Type
Name Field5 Type
Name Field6 Type
Name Field7 Type