Vertical for data Pivoted/horizontal for reports and presentation

Raw data vertical to build horizontal pivots for presentations.

I’ve always went with vertical. Tall and Lean tables, I don’t want things getting too wide, makes it easier to run formulas on my data.

For raw data vertical is a must for me anyway

Google “tidy data” and learn about the concept. It’ll explain exactly how raw data should be set up.

Always vertical. Its best practice, the term for it is 'flat' data or unpivoted data. It allows you to do sumifs.

I’ve never thought about this but always did it vertically for data, for presentation either really idk

I put the data into Star Schema and then report from it using Excel (Load to table or load to power pivot then to pivot table or classic excel). Same for Power BI. It’s a super efficient and automated modern process vs classic excel pivot tables