Greeting,

Im trying to get data from Sheet2 that has data vertically (by row) and bring it to Sheet1 into a horizontal position. The criteria is in Sheet1 a Date (that is unique value in the lookup) is placed in cell A1 then a lookup formula return the entire row of data from Sheet2 for that date and place horizontally in Sheet1 in A2 and downwards. How can do this, Ive tried vlookup, hlookup, Index, transpose you name it!

Appreciate any help!