I am new to VBA coding and am trying to write a VBA code to transpose a single column to a single row with duplicates removed. This length of the list can vary.

In column B contains
1
1
2
3
4
3

I would like to transpose starting at "F1" and the row would look like this
F1 G1 H1
1 2 3

What VBA code can accomplish this?