#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Hi
The easiest way to achieve what you want is to transpose your source data from columns to rows. Then use your formula as normal i.e. =Sheet1!C5 and then drag it down your target column and it will pick up the correct values from your source data. Good luck. Tony |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Transpose Issue (need custom increment on auto fill down) | gretchen | Excel | 3 | 11-28-2012 02:33 PM |
How to transpose the datas of part code and supplier into row and column | PRADEEPB270 | Excel | 3 | 10-26-2012 07:22 PM |
skip to next sentence? | moreenz | Word | 3 | 08-16-2012 02:41 PM |
skip duplicate letters | karen h | Mail Merge | 10 | 03-23-2011 08:37 AM |
How to skip the credential checking step | charleslt1900 | Outlook | 2 | 08-19-2010 04:02 PM |