How to batch transpose groups to columns when groups take up various rows

If you want to continue thinking in terms of transposing data I suggest you just insert missing rows in the original data so that all groups have the same number of rows. Remember that you probably have to do that from the bottom up because row numbers will change as you insert rows above the current row.

As an alternative you might think of transferring data. In that method you would pick the data you want from each group and copy/paste them to their correct column in a destination worksheet.

Either way, the key is to be able to identify the data. In your representative data that is simple. "Year" is year and "Value" is value. In your real data row titles might vary. So you would need to find a genereic way of identification. Perhaps the last row in a group is always "Value". You don't say which data you need. Perhaps you want some of the titles as well.

So, my answer is that the method you employ, transpose or transfer, is a question of how you manage to identfy the rows - and how many groups you have. As a rule of thumb, the transposed data probably need additional work even after they have been sorted into columns. A transfer is more likely to give you a final result immedaitely. Therefore you might be willing to invest more time in such a solution.

I'd like to ask you this: I'd like to transpose (or transferring) my data from Rows into Columns following this example:

1 | Title | Auth | Time

2 | Title | Auth | Time

3 | Title | Auth | Time

to

1 | Title | Auth | Time  -  2 | Title | Auth | Time -  3 | Title | Auth | Time

I have some item with 3 titles, some 5 or more. When the number is equal to "1" need it is a new Row (product).

Thank you for your help.