Using the Input Tool or any other tool

[Kallis]

Hi Friends

Region	DC	Country	Dec'24
Samples	Defectives

This is the header of an Excel sheet. A, B & C are in row 1 whereas D & E are in row 2. If all the headers are in row 2, I can enter 2 against start date import on line but with this scenario, please let me know how can I extract the headers.

Thanks

[martinson]

Hi @Kallis how is your data structured under the headers?

[Kallis]

Hi @martinson 

This is how the data looks like

Country	Dec'24
Samples	Others
China	1559
Japan	2529
Korea	20
Hong Kong	77
Thailand	73
Vietnam	382
Taiwan	262

[martinson]

Hi @Kallis I'm still a little confused about what manipulation you would like done to your data. Extracting headers can be done with the dynamic rename tool or using the sample tool to extract the rows with the headers. Let me know if you could clarify what you are trying to do. 

Cheers,

martinson

[Kallis]

Hi @martinson 

It is alright. I will inform the vendor to change their file.