I have file with data for data_0 to data_4 repeated in rows. I need to convert it into columns values under respected dataset. Is there any way to put blank/null value in case data is missing for earlier category. For Example
TimeStamp,Block,No_of_requests
04:19:12,data_0,4
04:19:12,data_1,6
04:19:12,date_2,8
04:19:12,date_3,10
04:19:12,data_4,12
04:19:14,data_0,5
04:19:14,data_1,6
04:19:14,date_3,7
04:19:14,data_4,8
Expected output is
TimeStamp,data_0,data_1,data_2,data_3,data_4
04:19:12,4,6,8,10,12
04:19:14,5,6,,7,8
etc. It should put empty data incase value for respective data_x is not available.