Hi experts:

I have and excel sheet as a result of importing the report from an
accounting software/foxpro as follows:
Job name Material Budget
job No. Prj. Manager Material Actual
1 a123 Buldng A 15, 000
2 Mr. X 12.000
3

One job number takes 2 rows, that is the layout of the report extracted
*consits of hundred jobs)
How can I make a macro in order to change the above to have layout to be:
job No. JobName Prj Manager Material Budget Material Actual;
a123 Buldng A Mr. X 15,000 12,000

In order for me to use #vlookup" to return data in another summary sheet.

Any idea is appreciated.

Frank