transforming rows & columns

hi,

I have entries from an html form coming in through seperate emails. The info in each email looks like this:

First Name: John
Last Name: Doe
Email: [email protected]

I managed to get this into an Excel file where all entries from different people are in rows and columns like the attached example. Problem is that all the entries are underneath eachother...

Obviously, I need 3 columns: firstname, lastname, email with the correct info in them.


Is there anyone who would be so kind as to take a look and help me out?

thanks, koen

indexOmgezet.xlsx

here is the attachment

hi siva,

thanks for your effort,

but could you please elaborate a little on how to transform the original data with that formula?


thanks, koen

so, starting from my original file, how do I start?

What do I select? I suppose I need to copy your code =INDEX($B$1:$B$6,ROW(1:1)*3-3+COLUMN(A:A))

and then paste it in the formula zone?

thanks again.