Discard All columns when the 1st row is Blank or Null

[DataPirate26]

Hi all, 

I want to Discard all the columns in which the 1st row is null or blank. attached below is a sample. Can someone help me in this. 

I only need the Columns: BBDO Inc. and  BBDO Chicago. in the below sample. rest all needs to be discarded. 

Note: There are 100 fields. So I have to do this dynamically. This is just one sample. 

[Qiu · Accepted solution]

@DataPirate26 
I would use the sample tool to take the first row then use Transpose to rule out the Null value, which shall be filtered out.

For details refer below.

[DataPirate26]

@Qiu Thanx for the quick response. It worked Fine

[grazitti_sapna]

@DataPirate26 , here is another way to do this:

[Qiu]

@DataPirate26 
Glad to know it helps.

[DataPirate26]

@Qiu @grazitti_sapna Thanx for your quick response. I actually am facing one challenge in this. Basically few of the headers have characters Like "&" , "." in it which are also replaced by "_". when doing a Crosstab. 

Example: "Patients & Purpose"  "Agency.com" . The results are coming like Patients_Purpose and Agency_com. I can replace the "_" with a black space but that doesnt give me the original Headers. Can you help me out so that I can retain the original headers. 

[Qiu · Accepted solution]

@DataPirate26 
For this situation, I usually use the Dynamic Rename to bring the Column Name back.

[DataPirate26]

@Qiu Awesome. Thanx for the help and this is a great way to solve this kind of Small issues

[Qiu]

@DataPirate26 
Glad to help.