Data from rows to column

[iqbalshah]

I need to change rows data into column.
I have a table name as Temp_Report1 with fields Lab_No, Test Name, Reslt, Test_master

Lab_no
Test Name
Result
Test_Master
4.414
Hemoglobin
00
HAEMATOLOGY
4.414
Red Cells
01
HAEMATOLOGY
4.414
E.S.R
02
HAEMATOLOGY
4.414
Reticulocytes
03
HAEMATOLOGY

etc
etc


The another table where I want to copy data is New_repo2 with fields Lab_no, v1, v2, v3 etc.
Need as
Lab_No
V1
V2
V3
V4
V5…
4.414
Hemoglobin
Red Cells
E.S.R
Reticulocytes
Etc

How to change this from rows to one column, I need query or VB6 code. Thanks

 

[JHB]

I need to change rows data into column.

Create a cross tab query.