Horizontal Range to Vertical Range in Excel
With the advent of Power Pivot the task of flipping data is made very simple. The Unpivot Other Columns command is a bit of a game changer. It easily moves data from horizontal to the more database friendly vertical range very nicely.
Read MoreUnion An Excel Range and Transpose
I was asked by a colleague to transpose a range in blocks of 5 from horizontal to vertical. The data was arranged in 7 columns but he wanted the data split into from tabular data to headings on the vertical and the body text going across the columns. Each block of data was colour coded and this colour scheme was meant to be kept in the output page. It is an interesting problem and I decided to include a union range so I could include the header row (giving meaning to the data) each time a block of 5 rows was copied and transposed to the new sheet.
Read MoreFeatured Posts
Recent Posts
Split File into Parts and Save to Directory April 20, 2024
Most Popular Author December 14, 2023
Creating an Excel Dashboard - A Guide with Templates December 8, 2023
Real Estate Excel Dashboard October 11, 2023
Updating Excel Dashboards September 29, 2023
TheSmallman in Another Top Blog Rank April 24, 2023
Project Tracking Dashboard March 25, 2023
Excel Unique Formula September 17, 2022
Horizontal Range to Vertical Range in Excel June 15, 2022
Hiding Rows Quickly with VBA May 20, 2022