Excel Form Format to Spreadsheet Format
 

Hi,

I have separate excel spreadsheets that are in a form format. I need to
combine these separate spreadsheets into one spreadsheet. What is the best
way to accomplish this?

Excel Form Format to Spreadsheet Format
 

What do you mean by form format?
--
Brevity is the soul of wit.


"Karen" wrote:

Hi,

I have separate excel spreadsheets that are in a form format. I need to
combine these separate spreadsheets into one spreadsheet. What is the best
way to accomplish this?

Excel Form Format to Spreadsheet Format
 

Sorry about that. Each individual spreadsheet is in this format
Example:

State: CA Prep Date: 9/13/2005
Name: Fred Num: 544
Eff Date: 10/1/2005 Emp: 28

I need to place them all into one spreadsheet in this format.
State Prep Date Name Num EffDate Emp
CA 9/13/2005 Fred 544 10/1/2005 28


"Dave F" wrote:

What do you mean by form format?
--
Brevity is the soul of wit.


"Karen" wrote:

Hi,

I have separate excel spreadsheets that are in a form format. I need to
combine these separate spreadsheets into one spreadsheet. What is the best
way to accomplish this?

Excel Form Format to Spreadsheet Format
 

Copy everything then paste special--transpose.

Depending on how your data is formatted you may have to do some manual
adjustments. If the amount of data you're talking about here is too much to
do manual adjustments you will need a macro which can organize the data for
you correctly.

Dave
--
Brevity is the soul of wit.


"Karen" wrote:

Sorry about that. Each individual spreadsheet is in this format
Example:

State: CA Prep Date: 9/13/2005
Name: Fred Num: 544
Eff Date: 10/1/2005 Emp: 28

I need to place them all into one spreadsheet in this format.
State Prep Date Name Num EffDate Emp
CA 9/13/2005 Fred 544 10/1/2005 28


"Dave F" wrote:

What do you mean by form format?
--
Brevity is the soul of wit.


"Karen" wrote:

Hi,

I have separate excel spreadsheets that are in a form format. I need to
combine these separate spreadsheets into one spreadsheet. What is the best
way to accomplish this?

Excel Form Format to Spreadsheet Format
 

I have several of these that I need to combine into one spreadsheet.

"Dave F" wrote:

Copy everything then paste special--transpose.

Depending on how your data is formatted you may have to do some manual
adjustments. If the amount of data you're talking about here is too much to
do manual adjustments you will need a macro which can organize the data for
you correctly.

Dave
--
Brevity is the soul of wit.


"Karen" wrote:

Sorry about that. Each individual spreadsheet is in this format
Example:

State: CA Prep Date: 9/13/2005
Name: Fred Num: 544
Eff Date: 10/1/2005 Emp: 28

I need to place them all into one spreadsheet in this format.
State Prep Date Name Num EffDate Emp
CA 9/13/2005 Fred 544 10/1/2005 28


"Dave F" wrote:

What do you mean by form format?
--
Brevity is the soul of wit.


"Karen" wrote:

Hi,

I have separate excel spreadsheets that are in a form format. I need to
combine these separate spreadsheets into one spreadsheet. What is the best
way to accomplish this?