Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 12-31-2012, 10:39 AM
ItsjustB ItsjustB is offline Transpose cells and skip? Windows XP Transpose cells and skip? Office 2007
Transpose cells and skip?
Join Date: Dec 2012
Posts: 1
ItsjustB is on a distinguished road
Default 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.
Attached Files
File Type: xlsx Example.xlsx (11.4 KB, 9 views)
Reply With Quote
Old 01-09-2013, 08:53 AM
OTPM OTPM is offline Transpose cells and skip? Windows 7 32bit Transpose cells and skip? Office 2010 32bit
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road

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.
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Transpose cells and skip? 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
Transpose cells and skip? skip to next sentence? moreenz Word 3 08-16-2012 02:41 PM
Transpose cells and skip? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:33 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd. is not affiliated with Microsoft