I've got a unique issue. Someone sent me a spreadsheet that I'm trying
to put into a database (mysql) and i figured i could import it as a
csv file into mysql. But instead of them putting in data vertically
with the entries going down the numbers, they did it horizontally. To
explain, they did:

HORIZONTAL

Name John David
Tel 12345 45677
Zip 10001 10002

instead of VERTICAL

Name Tel Zip
John 12345 10001
David 45677 10002


So now I don't know if excel will handle all the records or could be
exported into a csv file properly. Vertical will list records properly
in a csv file, e.g.
1, John, 12345, 10001
2, David, 45677, 10002

But doing a csv dump with #2 will yield
1, John, David
2, 12345, 45677
3,10001, 10002

So what can I do to correct this? As the data is in cells, I'm
thinking there is some function that should be able to fix this...

It depends on the number of records.
If there aren't too many (or if you happen to have Excel2007), you can copy the data and then Paste Special and check Transpose.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"JNation Rocks!" <tkdin_NO_SPAM_thecity@Ya_NO_S_P_AM_hoo.com> wrote in message news:(E-Mail Removed)...
| I've got a unique issue. Someone sent me a spreadsheet that I'm trying
| to put into a database (mysql) and i figured i could import it as a
| csv file into mysql. But instead of them putting in data vertically
| with the entries going down the numbers, they did it horizontally. To
| explain, they did:
|
| HORIZONTAL
|
| Name John David
| Tel 12345 45677
| Zip 10001 10002
|
| instead of VERTICAL
|
| Name Tel Zip
| John 12345 10001
| David 45677 10002
|
|
| So now I don't know if excel will handle all the records or could be
| exported into a csv file properly. Vertical will list records properly
| in a csv file, e.g.
| 1, John, 12345, 10001
| 2, David, 45677, 10002
|
| But doing a csv dump with #2 will yield
| 1, John, David
| 2, 12345, 45677
| 3,10001, 10002
|
| So what can I do to correct this? As the data is in cells, I'm
| thinking there is some function that should be able to fix this...
|
|

1. Select the entire range of your horizontal data.
2. Press CTRL-C to copy.
3. Go to another worksheet in your workbook.
4. Edit->Paste Special and make sure you check the "Transpose" check box.

Now you have your data in the VERTICAL format and do your CSV dump.



"JNation Rocks!" <tkdin_NO_SPAM_thecity@Ya_NO_S_P_AM_hoo.com> wrote in
message news:(E-Mail Removed)...
> I've got a unique issue. Someone sent me a spreadsheet that I'm trying
> to put into a database (mysql) and i figured i could import it as a
> csv file into mysql. But instead of them putting in data vertically
> with the entries going down the numbers, they did it horizontally. To
> explain, they did:
>
> HORIZONTAL
>
> Name John David
> Tel 12345 45677
> Zip 10001 10002
>
> instead of VERTICAL
>
> Name Tel Zip
> John 12345 10001
> David 45677 10002
>
>
> So now I don't know if excel will handle all the records or could be
> exported into a csv file properly. Vertical will list records properly
> in a csv file, e.g.
> 1, John, 12345, 10001
> 2, David, 45677, 10002
>
> But doing a csv dump with #2 will yield
> 1, John, David
> 2, 12345, 45677
> 3,10001, 10002
>
> So what can I do to correct this? As the data is in cells, I'm
> thinking there is some function that should be able to fix this...
>



----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----