How to Transform row to Column and Column to Row

[brijeshvma]

Lot  No	Barcode	Process	Marks1	Marks 2	Header 6	Header 7	Header 8	Header 9	Header 10
A1	A1-001	1 Pred	10	20
A1	A1-001	2 pred	20
A1	A1-001	3 pred	30
A1	A1-001	Final	30
B1	B1-001	1 Pred	20
B1	B1-001	2 pred	43
B1	B1-001	3 pred	34
B1	B1-001	Final	54

[sunny_talwar]

For row to column you can use Generic Load - The Generic Load

For column to row you can use CrossTable Load - The Crosstable Load