Transpose table

[HananJanaby]

Hi,



I have two Excel sheets, 1st one, contains one columns of the headers
2nd sheet contains the fields that corresponds to each header on the 1st sheet.

How can i combine the two sheets and and gets each field corresponds to its header.

Thanks in advance,
Hanan

[davegri]

Add a row at the top of the second sheet and copy the header row there from the first sheet.

[HananJanaby]

but how will that link between the headers and its corresponds fields .. there is no link between the two sheets

[davegri]

I was assuming that you wanted to prepare a sheet to easily import into Access. If your question is strictly about Excel Dlookup and such, I can't address that.

[alansidman]

crossposted: https://www.excelforum.com/excel-pro...ml#post5110956