Hi there,
I am new to Excel and I suck, after searching for a solution in excel help directory and on the net I decided to post my questions to the excel experts here :-)
It's probably very simple but I don't know how to do it:
I have imported data from a text file to a csv file simply by saving the text file as a .csv. The text file contained emails separated by ";". When I converted to .csv I ended up with the bulk of the emails spread on 1 row and multiple columns (1 email per column) I actually would like to perform the other way around: 1 column and then multiple rows (1 row per email)
So instead of having all data on a single row with multiple columns such as:
email tab A - email tab B - email tab C - email tab X^100
I would like to have data on a single column but with multiple rows:
Email row 1
Email row 2
Email row 3
Email row X^100
How could I do that? A solution either before converting to csv or once in csv format solutions are fine to me...
The purpose of this is to import emails to a database which only read emails in .csv format and displayed by rows, not columns)
Thanks guys!
Bookmarks