Write into excel with empty cells in column

[Kavya_Mamidishetti2 (Kavya)]

Hi all,
I have Names, Details, Data column values in List.
Names={“Robet”,“John”,“Jack”}

RobetDetails={“Phone”,“Address”}
JohnDetails={“Phone”,“Email”,“Address”,“Designation”}
JackDetails={“Address”,“Email”,“Designation”}

RobertData={“9898989898”,“India”}
JohnData={“7878787878","j@gmail.com”,“Chennai”,“SE”}
JackData={“Gurgaon","jack@gmail.com”,“SSE”}

I want to represent list data into excel in the below format.
Thanks in advance…!

[Srini84 (Srinivas)]

@Kavya_Mamidishetti2

Check below for your reference

Reference

Thanks & Regards,
Srinivas K

[ermanoj3101 (MANOJ)]

Hi @Kavya_Mamidishetti2 ,

You mean you have 7 different list, is that correct ?

[Kavya_Mamidishetti2 (Kavya)]

@Srini84 okay.Thanks

[Kavya_Mamidishetti2 (Kavya)]

@ermanoj3101 yes. you are right and I have many more.

[ermanoj3101 (MANOJ)]

Are you creating these list on runtime ?
I feel this data you are getting from json.

If it’s json data,can you share your json file or json data ?

[Kavya_Mamidishetti2 (Kavya)]

Yes.I’m getting this data at runtime.I’m extracting the strings from text file using regular expressions and storing into list.I want to write that data into excel in the mentioned format.I don’t have json file.