Openpyxl -Coming up with a single column from a multi column data set

[Givan007]

Hello,

I am just starting with manipulating xlsx data sets with openpyxl. How would I start looking at selecting/using openpyxl commands to select one column at a time and placing each of the columns data underneath the 1st one? Then I would like to eliminate duplicates, but still keep it within one column.

Each data column will end with an empty cell

Column1, Column2, Column3, .....ColumnN ( no more than 30 columns)
1230, Robert, Car
Robert, 1230, Car
Alfred, 3456, empty
Richard, empty, empty

etc.

Result Below:

Column1
1230
Robert
Alfred
Richard
3456
Car

..
Etc.

Thank you for any feedback.

[Prabakaran141]

Try out with below documentation,
https://openpyxl.readthedocs.io/en/stable/

People will help, when you come up with issues. Forum is not a place to ask for coding to your requirement.