Group Data Labels Horizontally

Hi,

Can I check if there is a way that I can group my data in Column B (Value) horizontally from the main data in column A (header). I have attached a file to further explain what I want to do. Sheet 1 is the data spread sheet and sheet 2 is what I hope I can accomplished.

I have tried to use pivot table but my relatively limited knowledge with excel failed to come out with a way to do it. Hope some of the expert here can help me with it

Regards
Darrell

Hi,

Please check attached excel sheet. It will solve your problem.

Create a unique list showing your values and then pivot it.

Regards,
Ankit

Hi Ankit,

Will it be possible if I do not have any blank cell in between each header and value? In another words, each different header will have their value side by side.



Regards
Darrell

Hi Darrell,

PFA..

For blank, we can select insert blank after each item from pivot table.

Regards,
Ankit

Hi Ankit,

Thank you

Regards
Darrell