Can you control the data in the CSV? It seems like it's missing a comma in the second line. A proper CSV file that has a blank value should still have the same number of columns. It should technically be as follows:
Tom Thomas, Cleark, Amazon
Amy,, Yahoo
Tony Deb, Developer, Microsoft
(Notice the two commas between "Amy" and "Yahoo" - this indicates a blank field).
If it looked like that, it would be very easy to simply read the file via Read from CSV file and then Write to Excel worksheet.
If, however, you cannot control your file, it will be tricky to make this work, because there is no way to automatically know which exact field you're missing. You might have a name and a designation, but no company name.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
