G
Gani tpt
Guest
Hi,
I have client excel template which contains many columns and rows. The row always dynamic.
some of the columns has merged in the attached excel sheet (Ex. Remarks column (it merged almost 5 columns and becomes one column finally i.e (X12 : AC12).
I want to get all the columns which is the row starting from Row no : 12.
meanwhile i want to fetch all the rows in the first columns.
My final output columns should be : A,B,C,D.........VR14 (Excel column and row range starts from A12 : BW12)
How do i convert this template into data table..
Herewith attached excel template. --- Test File - Client Template
Continue reading...
I have client excel template which contains many columns and rows. The row always dynamic.
some of the columns has merged in the attached excel sheet (Ex. Remarks column (it merged almost 5 columns and becomes one column finally i.e (X12 : AC12).
I want to get all the columns which is the row starting from Row no : 12.
meanwhile i want to fetch all the rows in the first columns.
My final output columns should be : A,B,C,D.........VR14 (Excel column and row range starts from A12 : BW12)
How do i convert this template into data table..
Herewith attached excel template. --- Test File - Client Template
Continue reading...