R1C1 reference style Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/r1c1-reference-style/ Bestselling Excel and Power BI Courses Wed, 01 Mar 2023 19:56:05 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png R1C1 reference style Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/r1c1-reference-style/ 32 32 Excel Hack to Change Horizontal Data to Vertical https://www.xelplus.com/excel-horizontal-data-to-vertical/ Sat, 11 May 2019 20:40:00 +0000 https://www.xelplus.com/?p=12358 Here's an Excel Hack that shows an unusual but simple method to change horizontal data to vertical. The advantage of this hack is it's dynamic so if you add more values to the horizontal data it will reflect in the vertical one.

The post Excel Hack to Change Horizontal Data to Vertical appeared first on Xelplus - Leila Gharani.

]]>