A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Make Excel see columns as rows and rows as columns



 
 
Thread Tools Display Modes
  #1  
Old November 17th, 2009, 08:10 PM posted to microsoft.public.excel.misc
Xane
external usenet poster
 
Posts: 8
Default Make Excel see columns as rows and rows as columns

Okay, I have a bit of a difficult problem. I'm using excel to make a map for
a game I'm playing. I've already converted the columns to numbers as well,
however the game's mapping system is inverted from Excel's, meaning that for
example 13,100 doesn't get you to row 13 and column 100, but to column 13 and
row 100.

Can I switch this around somehow in Excel?
Can I make Excel take columns before rows, so 13,100 will actually mean
column 13, row 100?

Thanks!
  #2  
Old November 17th, 2009, 09:56 PM posted to microsoft.public.excel.misc
David Biddulph
external usenet poster
 
Posts: 8,714
Default Make Excel see columns as rows and rows as columns

It isn't clear what formula you are using, but there should be a number of
alternatives.
One choice would be just to swap the order of your parameters.
Another might be to use the TRANSPOSE function.
--
David Biddulph

"Xane" wrote in message
...
Okay, I have a bit of a difficult problem. I'm using excel to make a map
for
a game I'm playing. I've already converted the columns to numbers as well,
however the game's mapping system is inverted from Excel's, meaning that
for
example 13,100 doesn't get you to row 13 and column 100, but to column 13
and
row 100.

Can I switch this around somehow in Excel?
Can I make Excel take columns before rows, so 13,100 will actually mean
column 13, row 100?

Thanks!



  #3  
Old November 17th, 2009, 10:30 PM posted to microsoft.public.excel.misc
JLatham
external usenet poster
 
Posts: 1,896
Default Make Excel see columns as rows and rows as columns

How are you addressing the cells? In a formula, in VBA code? If a formula,
give us an example.

"Xane" wrote:

Okay, I have a bit of a difficult problem. I'm using excel to make a map for
a game I'm playing. I've already converted the columns to numbers as well,
however the game's mapping system is inverted from Excel's, meaning that for
example 13,100 doesn't get you to row 13 and column 100, but to column 13 and
row 100.

Can I switch this around somehow in Excel?
Can I make Excel take columns before rows, so 13,100 will actually mean
column 13, row 100?

Thanks!

  #4  
Old November 18th, 2009, 02:00 AM posted to microsoft.public.excel.misc
Mdegraaf
external usenet poster
 
Posts: 2
Default Make Excel see columns as rows and rows as columns

Let me try to clarify the problem:

The map I'm working with has a coordinate system that is inversely set up
compared to excel's, meaning that every length coordinate on the map is a
width coordinate in Excel and vice versa.

What I'm trying to do, is take the coordinates of the game map and use them
to fabricate my own map in excel. I'm not trying to calculate anything or use
any formulas. I just want to use all the cells of the map to simulate all the
spaces on the map and enter a name or some text and a colour.

However, since the coordinate system of the game has the X and Y axis
switched, my map would come out tilted 90 degrees if I were to make this map
with the coordinates I take from the game (top would be left, left would be
bottom, etc), which of course is not very practical. I could tell everyone to
print the map, but that would be a huge puzzle and simply undoable, not to
mention that it'll need to be updated constantly.



In short... I just need to somehow rotate my worksheet 90 degrees
counterclockwise...





"David Biddulph" wrote:

It isn't clear what formula you are using, but there should be a number of
alternatives.
One choice would be just to swap the order of your parameters.
Another might be to use the TRANSPOSE function.
--
David Biddulph

"Xane" wrote in message
...
Okay, I have a bit of a difficult problem. I'm using excel to make a map
for
a game I'm playing. I've already converted the columns to numbers as well,
however the game's mapping system is inverted from Excel's, meaning that
for
example 13,100 doesn't get you to row 13 and column 100, but to column 13
and
row 100.

Can I switch this around somehow in Excel?
Can I make Excel take columns before rows, so 13,100 will actually mean
column 13, row 100?

Thanks!



.

  #5  
Old November 18th, 2009, 02:38 AM posted to microsoft.public.excel.misc
Mdegraaf
external usenet poster
 
Posts: 2
Default Make Excel see columns as rows and rows as columns

Oh, this is Xane btw, I just changed my screen name.
  #6  
Old November 18th, 2009, 06:24 AM posted to microsoft.public.excel.misc
David Biddulph
external usenet poster
 
Posts: 8,714
Default Make Excel see columns as rows and rows as columns

If you've got X and Y transposed, then you don't just have a 90 degree
rotation, but you've also got a reflection, in that a clockwise turn becomes
anti-clockwise.
It sounds as if you need to copy your data, then Edit/ Paste Special/
Transspose.
--
David Biddulph

"Mdegraaf" wrote in message
...
Let me try to clarify the problem:

The map I'm working with has a coordinate system that is inversely set up
compared to excel's, meaning that every length coordinate on the map is a
width coordinate in Excel and vice versa.

What I'm trying to do, is take the coordinates of the game map and use
them
to fabricate my own map in excel. I'm not trying to calculate anything or
use
any formulas. I just want to use all the cells of the map to simulate all
the
spaces on the map and enter a name or some text and a colour.

However, since the coordinate system of the game has the X and Y axis
switched, my map would come out tilted 90 degrees if I were to make this
map
with the coordinates I take from the game (top would be left, left would
be
bottom, etc), which of course is not very practical. I could tell everyone
to
print the map, but that would be a huge puzzle and simply undoable, not to
mention that it'll need to be updated constantly.



In short... I just need to somehow rotate my worksheet 90 degrees
counterclockwise...





"David Biddulph" wrote:

It isn't clear what formula you are using, but there should be a number
of
alternatives.
One choice would be just to swap the order of your parameters.
Another might be to use the TRANSPOSE function.
--
David Biddulph

"Xane" wrote in message
...
Okay, I have a bit of a difficult problem. I'm using excel to make a
map
for
a game I'm playing. I've already converted the columns to numbers as
well,
however the game's mapping system is inverted from Excel's, meaning
that
for
example 13,100 doesn't get you to row 13 and column 100, but to column
13
and
row 100.

Can I switch this around somehow in Excel?
Can I make Excel take columns before rows, so 13,100 will actually mean
column 13, row 100?

Thanks!



.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:28 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.