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.
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.