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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
Make Excel see columns as rows and rows as columns
Oh, this is Xane btw, I just changed my screen name.
|
#6
|
|||
|
|||
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 | |
|
|