I am new to python. I would like to copy multiple columns to single column in a excel using python. And in that single column first heading and then value if the value is not present the that column should not copy.
Example Excel data:
| Column A | Column B | Column C | Column D |
|---|---|---|---|
| One | Two | Three | Four |
| Five | Six | Seven | |
| xyz | hjy | abc |
Excepted Result:
| Column A | Column B | Column C | Column D | Column E |
|---|---|---|---|---|
| One | Two | Three | Column A :One, Column B:Two, Column C:Three | |
| Five | Six | Seven | Column A :Five, Column C:Six, Column D:Seven | |
| xyz | hjy | abc | Column A :xyz, Column B:hjy, Column D:abc |
