How to unstack data in Excel 2007

Excel 2007 and above supports 2 ^ 14 columns, i.e. 16384 columns. They are labeled with the 26 letters of the alphabet, so the labeling is a 26 base system, not a 10 base system like our numbers.

In our 10 based numbering system we have the digits 0 to 9. We start numbering with 1 and the next number after 9 uses another digit and starts that digit at 0. Hence 1, 10, 100. (Strictly speaking, our numbering system should start with a 0 instead of a 1, but that's a different story).

In Excel, columns are numbered with a system that has 26 digits instead of 10.

The first 26 columns are A to Z. The 27th column uses another digit and starts that digit at A, hence AA.

column 26 = Z

column 27 = AA

column 28 = AB

column 29 = AC

...

column 52 = AZ

column 53 = BA

column 54 = BB

...

When all the two-digit headers have been used, another digit is added.

column 702 = ZZ

column 703 = AAA

column 704 = AAB

... 

... and finally

column 16384 = XFD

In a 26 base system, the value XFD equals 16384.

Excel 2007 and above supports 2 ^ 20 rows, i.e. 1048576 rows. They are just numbered from 1 to 1048576.

___________________
cheers, teylyn
 
Community moderator
www.teylyn.com

Report abuse

Harassment is any behavior intended to disturb or upset a person or group of people. Threats include any threat of suicide, violence, or harm to another. Any content of an adult theme or inappropriate to a community web site. Any image, link, or discussion of nudity. Any behavior that is insulting, rude, vulgar, desecrating, or showing disrespect. Any behavior that appears to violate End user license agreements, including providing product keys or links to pirated software. Unsolicited bulk mail or bulk advertising. Any link to or advocacy of virus, spyware, malware, or phishing sites. Any other inappropriate content or behavior as defined by the Terms of Use or Code of Conduct. Any image, link, or discussion related to child pornography, child nudity, or other child abuse or exploitation.
Details (required):
250 characters remaining

617 people found this reply helpful

ยท

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.