How to remove particular column from dataset which are present in list

[prthmesh111]

I am having a list of book present in excel like below format

Bookid

Flax123

Flax461

Strt310

From the input data i am reading the file which the columns present in that list like  below

Ab12-34  Flax123-xyz Strt310-abc  Lmn123

122.          123345.         122344.        Oepejd

123455.    Jdjldldp.        Wejrjdjb.       Jdjdjdk

Whatever the column names that are contains in  dataset from that list should be removed or delete in the output 

[pedrodrfaria]

Hi @prthmesh111 

If I understood it correctly, you are looking for something like this:

Here we removed two column headers that were on the other list.

[mceleavey]

Hi @prthmesh111 ,

A little bit of transpose and crosstab magic should to the trick:

[Qiu]

@prthmesh111 
Hope this will work

[prthmesh111]

HI QUI,

It works fine but if you look at column name (-) is getting replace with ( _ )  is there any way to keep the same column name as it