Can i use the first column values as column headers?

[#1]

Hi all,

My raw excel data format is as per below

Eval No.	Evaluation 1	Evaluation 2	Evaluation 3	Evaluation 4
Evaluator Name:	W	X	Y	Z
Staff Name:	A	B	C	D
Score	70	80	90	100

What i want is the first column values to become the column headers, and the remaining column data to become the row data

Eval No.	Evaluator Name:	Staff Name:	Score
Evaluation 1	W	A	70
Evaluation 2	X	B	80
Evaluation 3	Y	C	90
Evaluation 4	Z	D	100

I would like to know how i can do this without tampering with the raw excel data format. Thank you.

[tamilarasu · Accepted solution]

Hi Leow,

You can use Transformation wizard to achieve the above result.

LOAD [Eval No.],

     [Evaluator Name:],

     [Staff Name:],

     Score

FROM

Book11.xlsx

(ooxml, embedded labels, table is Sheet1, filters(

Transpose()

));

[MarcoWedel]

Hi,

the Import wizard can help you with this kind of transformations.

Just use the transpose option you can find there.

Regards

Marco

[Anonymous]

while load the data from excel file use transformation step...

[Gysbert_Wassenaar]

You can also try a CrossTable load:

CrossTable(EvaluationNumber, Value)

LOAD * FROM MyExcelFile.xlsx (ooxml, embedded labels, table is Sheet1);