Hello all,
Temp.xlsx (9.9 KB)
I m getting data in the above format. Now i want to split the Normal data as per the date. But the problem is that, Some dates are blank data i want data of Normal column from date 1 to 31 with null values as per the table… Suppose if dates between 1 to 16 have null values then also i want as null… Plz help me getting this done…
@Omkar_Shete_CTR I don’t really get, what you want to achieve… Maybe you could provide an Excel with the format you want to have?
Hi,
Normal W 1 1 1 1 1 1 W 1 1 1 1 1 W 1 1 1 1 1 1 W 1 1 1 1 1 1 W 1 1
I want output to be like this in the single excel row of Normal only… with the blank value…
@Omkar_Shete_CTR please provide an excel with the Format you are having now and another one with the Format you want to achieve… From your description it ist very hard to Unterstand your actual Challenge unfortunately…
This is solved by me. Thank you for your help
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.