Excel Question (:

Submitted by TKDJamesPakTKD on Sun, 10/01/2010 - 7:29am
I have a spreadsheet of all of the items in my sdb that relate to my category (petpets). On there I have prices of all the prices I have bought it for so when I put it into portal it will be more convienent for me. However, when I made this list I have the items listed vertically and the prices going horizontally.. is there a way to switch this up and have the items listed on the top horizontally and the prices going down vertically..? or do I have to remake the whole thing? Also when I have the items listed is there a way to make the first values at 1 instead of having the names start at 1?
Forums: 
General Chat - NON NEOPETS RELATED
  • 8465 reads

If I get your first question right, you can transpose your table by select all or select the table, then right click on where you want to put it (new sheet may be better), click Paste Special and check Transpose =D Sorry I don't get your second question tho xD -----------=^_^=----------- I bite. Ik bijt. Aku gigit.
-----------=^_^=----------- I bite. Ik bijt. Aku gigit.
kittenz | Sun, 10/01/2010 - 7:39am |

ohh thanks ill try that now (: mm.. my 2nd question is that when you enter the names and stuff on the top? the column says 1,2,3,4,5,6,7,etc. (on the left side) but when you write the names it puts it on column 1 .. is there a way to make the names not a column and the values start as column 1? ------------------------------- See my new screenie petpage? (: http://www.neopets.com/~TKDChampion www.youtube.com/TKDJamesPakTKD Check out my Martial Arts samplers =)
------------------------------- www.youtube.com/TKDJamesPakTKD Check out my Martial Arts samplers =)
TKDJamesPakTKD | Sun, 10/01/2010 - 7:43am |

Ahh, ok, I think I understand that you don't want the count to start at the Name, but at the Value itself. Don't think you can do that in Excel :(, I know it's like that in Statistical Softwares tho! xD Tho maybe an Excel Guru out there may know better :o Did the transposing work? -----------=^_^=----------- I bite. Ik bijt. Aku gigit.
-----------=^_^=----------- I bite. Ik bijt. Aku gigit.
kittenz | Sun, 10/01/2010 - 8:00am |

it worked !! ^_^ thanks xD beats copy it one by one *lol* ------------------------------- See my new screenie petpage? (: http://www.neopets.com/~TKDChampion www.youtube.com/TKDJamesPakTKD Check out my Martial Arts samplers =)
------------------------------- www.youtube.com/TKDJamesPakTKD Check out my Martial Arts samplers =)
TKDJamesPakTKD | Sun, 10/01/2010 - 8:03am |

Explain to me a bit how you are trying to order it. You are typing in the fx bar hitting enter and wanting them to go somewhere other than where they are going?
perpette | Sun, 10/01/2010 - 8:21am |

oh okay.. like I'm typing it into row 1 like all the names and stuff but I don't want the rows to start until I begin typing numbers below it :O sorry i can't well at all LOL ------------------------------- See my new screenie petpage? (: http://www.neopets.com/~TKDChampion www.youtube.com/TKDJamesPakTKD Check out my Martial Arts samplers =)
------------------------------- www.youtube.com/TKDJamesPakTKD Check out my Martial Arts samplers =)
TKDJamesPakTKD | Sun, 10/01/2010 - 8:23am |

and you are wanting the numbers where? item price item price or item price item price
perpette | Sun, 10/01/2010 - 8:26am |

I think you best screenshot it and draw on it how you want it to look.. Think it's the only way to explain. I don't get it either, sorry.
kieke25 | Sun, 10/01/2010 - 8:27am |

the time it will take you to do this you could finish filling out the portal LOL
perpette | Sun, 10/01/2010 - 8:28am |

Ill take a screenie now.. my portal is already finished xD ------------------------------- See my new screenie petpage? (: http://www.neopets.com/~TKDChampion www.youtube.com/TKDJamesPakTKD Check out my Martial Arts samplers =)
------------------------------- www.youtube.com/TKDJamesPakTKD Check out my Martial Arts samplers =)
TKDJamesPakTKD | Sun, 10/01/2010 - 8:44am |

Pages