I'm looking to possibly transpose an excel spread sheet. Quite simply I need more columns than there are available. I know Excel has 65,365 rows by 256 columns. Is there a way to make it 65,365 columns by 256 rows? If so how?
working with the table transposed normally is not an option at the moment.
thanks
2006-12-14 21:27:41 · 3 answers · asked by Gav M 1 in Computers & Internet ➔ Programming & Design
Thanks guys. Been doing a bit of research too and came to the same conclusion Excel just doesn't hack it. I'm going onto Access now and with a bit of imagination I'm hoping to that should give me a way to get around this with multiple tables/sheets and so on.
FYI If anyone is interested (or has any inputs to share): I'm making a leave tracker from my company. 6 different kinds of leave. 6 large departments with sub groups (teams). trying to have all personal info and leave taken available for HR to draw quick reports and for supervisors to easily input data. duration needs to be 1 year at least (more years would be great).
I already created a working xls for this which does the job well but excel is too limiting with the size of the files.
2006-12-14 23:09:04 · update #1
It sounds to me like this job requires a tool more powerful than Excel!
2006-12-14 22:09:06 · answer #1 · answered by Anonymous · 0⤊ 0⤋
You could swap columns and rows by making the information you need in columns appear in rows and vice versa.
2006-12-14 21:47:25 · answer #2 · answered by Philbert 1 · 0⤊ 0⤋
here is your link
http://www.google.co.uk/search?hl=en&sa=X&oi=spell&resnum=0&ct=result&cd=1&q=Excel+maximum+number+of+columns&spell=1
2006-12-14 21:31:10 · answer #3 · answered by Joe_Young 6 · 0⤊ 0⤋