Short Answer: Nope
# general
e
Short Answer: Nope
m
@DL Long Answer: you can achieve some level of pivoting if you can hard code the columns, using grouping and formulas. But workbooks is definitely the preferred way.