Pulling a value on the same row from different column

[dummies]

hello friends,
please help with Pulling a value on the same row from different column using vba.
thank you

 

[Joe4]

Your question is not quite clear.
Please provide more details, maybe walk us through an actual example, referencing actual cell addresses.

 

[dummies]

Your question is not quite clear.
Please provide more details, maybe walk us through an actual example, referencing actual cell addresses.

thanks for the response.
i have two sheet , sheet one contain the data and sheet two contain the table where i can write the result pulled from sheet one.
i wanted to pull the data from multiply columns(sheet1) into single rows(sheet2).
for more information i have attached the screenshot below.
thank you so much.

.

 

[Joe4]

It looks like the set-up of your data sheet is an absolute nightmare!
Merged cells are just about the worst invention in Excel, and most accomplished programmers will avoid them like the plague!
They are extremely difficult to work with, and cause all sorts of issues for things like sorting and VBA.

Trying to look up data from such a structure can be quite daunting. If you have the ability to change it and work from a structure that contains no merged cells, it would probably be much better.
If not, I don't think it is anything that I can help you with.