I am stuck at a point and need urgent help it would be very helpful if anyone can help.
I have a text file i want to get the data of text file into an excel file,
the columns which are empty need to be removed, for them i can remove them later but my primary concern is getting data from txt file to excel file . File is attached
exmpl.txt (9.7 KB)
From the file i want the data only starting column 1 onwards i.e. headers onwards
column1,column4,column9,column10,column11,colum13,column18,column20 are empty
output file as an example is attached result.xlsx (8.5 KB)
please someone help me i am badly stuck.
defining again i need data of the text file in the excel file for all the rows.
for any queries please ask