1
vote
Accepted
Row and column "projection" in excel
Disclaimer: The following functions are only available on Excel365.
Use TOCOL and TOROW functions to create your "projections" vertically and horizontally.
TOCOL
=TOCOL(A1:C3;1)
TOROW
=...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
microsoft-excel-2016 × 1420microsoft-excel × 1124
worksheet-function × 437
vba × 137
charts × 92
microsoft-excel-2010 × 75
microsoft-excel-2013 × 72
pivot-table × 55
macros × 45
conditional-formatting × 44
windows-10 × 38
microsoft-office × 36
microsoft-excel-2007 × 34
power-query × 23
macos × 19
windows × 18
csv × 18
spreadsheet × 16
vlookup × 14
mac × 13
office365 × 13
sorting × 13
pivot-chart × 12
windows-7 × 10
keyboard-shortcuts × 10