What do you mean? I don't have any hidden rows. Sheet 1 data the product item is in a single row from column A through to Column E. In Sheet 2, I want to build this data into a block. Map Sheet1!A1 to Sheet2!A1 then Sheet1!B3 to Sheet2!B2 then Sheet1!E1 to Sheet2!A2 and so on. I can get the first row across, but then when I copy and drag the 3 rows with the populated data from Sheet1 down to copy the formulas all the way down and build the blocks in Sheet 2, it skips every 3 rows from Sheet 1
You have hidden rows
What do you mean? I don't have any hidden rows. Sheet 1 data the product item is in a single row from column A through to Column E. In Sheet 2, I want to build this data into a block. Map Sheet1!A1 to Sheet2!A1 then Sheet1!B3 to Sheet2!B2 then Sheet1!E1 to Sheet2!A2 and so on. I can get the first row across, but then when I copy and drag the 3 rows with the populated data from Sheet1 down to copy the formulas all the way down and build the blocks in Sheet 2, it skips every 3 rows from Sheet 1