LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
doran_doran
 
Posts: n/a
Default Excel fields in a row instead of column...


Hi,

I am back, LOL. Well, I have an Excel file but the data are in it looks
weired. I can't sort and do nothing. Column A has Title (Field Name)
about 13 Titles. Column B Contains the data. How can I convert or
import this data in access table. I haven't create a table with the
same fields in Excel. There is blank line between each records. So say
record one has 13 row so second records starts from the 15th row and
has 13 row for this record. Any idea. I have never received a file like
this.

PLEASE PLEASE PLEASE HELP FIND A LINK OR IDEA HOW DO I DO THIS.

MANY THANKS IN ADVANCE. Please see the print screen for clarity...

Thanks
Sarah Martinez


+-------------------------------------------------------------------+
|Filename: SP32-20050715-151445.gif |
|Download: http://www.excelforum.com/attachment.php?postid=3605 |
+-------------------------------------------------------------------+

--
doran_doran
------------------------------------------------------------------------
doran_doran's Profile: http://www.excelforum.com/member.php...o&userid=25274
View this thread: http://www.excelforum.com/showthread...hreadid=387655

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookup Table Dilemma Karen Excel Worksheet Functions 2 June 10th 05 08:22 PM
In MS Excel, how do I fill in a column with the same cell from se. krempin Excel Worksheet Functions 2 February 9th 05 08:43 PM
Column A is Town, Column B is names. How can Excel add & tell how. Cindy Charts and Charting in Excel 3 January 13th 05 07:27 PM
How do I sort a column of formulas in Excel? Gordon Excel Discussion (Misc queries) 2 November 27th 04 01:55 AM
Excel - option to extend function in cell to column kjoshua777 Excel Worksheet Functions 2 November 18th 04 01:08 AM


All times are GMT +1. The time now is 01:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"