Columnizing the output of excel

[petetipavan]

Hello everyone,

I export the data from SAP to excel, In SAP interface columns heads are divided in two rows. When I export the data into excel, it is exported the same way as it shows in SAP. I cant even columnize the text using text to columns function as it works only with single columns. I want column head and their respective data to be shown as a table in excel. Hope I have made myself clear.

Thank you,