Transpose cells and skip?
In the attached workbook I need to transpose some data AND skip cells as I do so. For example, the data for Sheet2!B4 is contained in Sheet1!A5, and the data for Sheet2!B5 is in Sheet1!B5.
Then the data for Sheet2!C4 is in Sheet1!C5, and the data for cell Sheet2!C5 is in Sheet1!D5.
This continues on for a whole bunch of cells (eventually the entire table in Sheet2 will be filled; I deleted a bunch of data from Sheet 1 for readability) or I'd just do this manually.
May I get some suggestions for how to do this with a minimum of pain? I was thinking of mapping cells (Sheet2!B4 =Sheet1!A5, Sheet2!B5 =Sheet1!B5) and then filling the series for the rest of the cells but I can't get Excel to understand the pattern?
Thanks in advance.
|