Excel Question (:

14 posts / 0 new
Last post
TKDJamesPakTKD
TKDJamesPakTKD's picture
Offline
Last seen: 10 years 8 months ago
Joined: 23/08/2009 - 9:48am
Excel Question (:
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?
kittenz
kittenz's picture
Offline
Last seen: 7 years 9 months ago
Joined: 02/11/2007 - 1:48am
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.
TKDJamesPakTKD
TKDJamesPakTKD's picture
Offline
Last seen: 10 years 8 months ago
Joined: 23/08/2009 - 9:48am
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 =)
kittenz
kittenz's picture
Offline
Last seen: 7 years 9 months ago
Joined: 02/11/2007 - 1:48am
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.
TKDJamesPakTKD
TKDJamesPakTKD's picture
Offline
Last seen: 10 years 8 months ago
Joined: 23/08/2009 - 9:48am
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 =)
perpette
perpette's picture
Offline
Last seen: 4 months 3 weeks ago
Joined: 27/01/2008 - 1:32pm
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?
TKDJamesPakTKD
TKDJamesPakTKD's picture
Offline
Last seen: 10 years 8 months ago
Joined: 23/08/2009 - 9:48am
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 =)
perpette
perpette's picture
Offline
Last seen: 4 months 3 weeks ago
Joined: 27/01/2008 - 1:32pm
and you are wanting the numbers where? item price item price or item price item price
kieke25
kieke25's picture
Offline
Last seen: 9 years 1 month ago
Joined: 19/04/2009 - 1:47pm
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.
perpette
perpette's picture
Offline
Last seen: 4 months 3 weeks ago
Joined: 27/01/2008 - 1:32pm
the time it will take you to do this you could finish filling out the portal LOL
TKDJamesPakTKD
TKDJamesPakTKD's picture
Offline
Last seen: 10 years 8 months ago
Joined: 23/08/2009 - 9:48am
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 =)

Pages