hello there, I know that the title is not very self explanatory but I really don't know how to explain what I need in 2 words. Attached you will find a file that can help understand what I need. I have this sheet (Data) where I have data inserted horizontally. I then copy this data vertically into the Results. What I need to achieve is that when data is inserted into Reports, the column name (highlighted) is shown in column F in Data. As you can see some highlighted cells are on top of the columns and some others at the bottom (all columns are of 4 cells).

Thanks for any help

Attached Files

test1.xlsm (8.4 KB, 24 views)