in that sheet1 excel file we have to take last 5 data of every colume
it means in the excel file there will be group of 3 colume after 1 colume is blue colour partetion
so in every 3 colume we have to take last 5 data of every partition
like these we did not take blank data only we have to complete full row data taken and paste into excel file like
i want output like these excel file output.xlsx (29.5 KB)
Yes output file was right because I have to copy all the colume means in excel file there will be 3 column partition so we have to take all the colume one by one to group of 3 that’s why data is more than 5 row
First 5 row data in the output file is first 3 colume group
After 5 row data is after partition 3 group of colume group
and these is colume scrreen shot
in that image can you show the last5 data of every 3 colume group after partition it will be new 3 colume group so we have to output file like these
these was the full explanation of my process is given below:-
in that sheet1 excel file we have to take last 5 data of every colume
it means in the excel file there will be group of 3 colume after 1 colume is blue colour partetion
so in every 3 colume we have to take last 5 data of every partition
like these we did not take blank data only we have to complete full row data taken and paste into excel file like
Yes output file was right because I have to copy all the colume means in excel file there will be 3 column partition so we have to take all the colume one by one to group of 3 that’s why data is more than 5 row
First 5 row data in the output file is first 3 colume group
After 5 row data is after partition 3 group of colume group