Transposing repeating vertical data to horizontal data but retaining unique values only

[mgcarino14]

Hi everyone! I need help with transposing repeating vertical data to horizontal data but retaining unique values only. Attached is the file containing original report and 'what I want' report.
Thanks in advance for any help that you can share Data_help.xlsx

[boopathiraja]

Hi, Welcome to the forum ,

A little pivot will help

Ref the attachment

[MarvinP]

Hi mgcarino and welcome to the forum,

Doing a little Design formatting on the answer above you can make it look more like your example. See the attached.

[mgcarino14]

Hi MarvinP and boopathiraja. Thank you for the alternate solutions on how to achieve the desired report. However, can you help me with a VB macro code on how to transpose all the data to meet 'what I want' format? I plan to just provide the users with a macro button that would help them fix the data based on the original report. Thanks.