Hi! I'm currently using the macro "Transpose every X number of rows" to batch-transpose some data.
However, the data I'm putting in Excel to then tranpose sometimes takes up 4 rows, sometimes 5, etc. As I'm currently inputting it in the Excel sheet, I have a blank row between every data "group." Is there any way to use a macro to transpose every GROUP of rows between blank lines (as opposed to by the number of rows)?
It would be okay if they got transposed to columns that didn't necessarily line up... I just would like to get the whole sheet laid out horizontally and then sort into the correct columns.
Here's an example of what my data looks like:
Title
Sub-title
Year
Value
Title
Year
Value
Title
Sub-Title
Location
Year
Value
Any thoughts?