Processing data (Transpone?)

[InfinityMrsn]

Hi Guys,

I would like to process data that is now in large numbers on rows. Some of this information I would like to have in rows below it.

Columns A through C contain product names+info and columns D, E and F contain data. The latter data I would like to have below each other, as I indicate in the example below.

Yellow is the data I have and green is the formatting I would like.

Does this require a VBA, or can I do this easily with a formula/macro.?

If you need more information, please let me know.

I would be very grateful as it would save me a tremendous amount of time

 

[Vogateer]

This looks like something you could do with a PivotTable, just adjusting some of the columns to be in tabular form.

 

[InfinityMrsn]

@Vogateer Thanks. I knew it was something like that. Couldn't figure it out. I think this will help me.

 

[Vogateer]

You're welcome. I should not that the Pivot Table wouldn't be exactly the same. In your examples you have all those values in the last column, but in a Pivot Table it would have them slightly offset below each other. It would look pretty similar, but if you really need all those values in the same column, we might need another solution. Using Power Query (Get Data) can put them in the same column, so that might be another option.

 

[InfinityMrsn]

@Vogateer Thanks, if it is not to many work, can you give me an example?