special type of rows to columns procedure

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "cretesupplies" <cretesupplies@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 3 Jun 2005 08:28:03 -0700

This is how i have the data
column1 column2 column3 column4
row1 1 2 3 4
row2 5 6 7 8
row3 9 10 11 12

And this how i would like to transform it with the most automated way i can.

column1 column2 column3 column4
row1 1
row2 2
row3 3
row4 4
row5 5 6 7 8
row6 9 10 11 12

Which means that i'd like Excel to insert new rows in order to paste the
"transposed" data and move the rest or the rows down.
I hope i was a bit more clear this time...and please excuse my not
proficient english!!!
Thank you in advance.

Stavros from CRETA SUPPLIES
instead of just

.

Follow-Ups:
- RE: special type of rows to columns procedure
  - From: Barb R.

Prev by Date: month
Next by Date: Re: month
Previous by thread: month
Next by thread: RE: special type of rows to columns procedure
Index(es):
- Date
- Thread

Relevant Pages

RE: SSIS string to int when a preceeding letter
... A four letter word for dba's and database developers! ... Use an OLE DB connector for the Excel file instead of the stock Excel ... Rows" to a Derived Column Transform. ... there is no CASE construct in SSIS. ...
(microsoft.public.sqlserver.dts)
Re: DTS Transform Loop
... controls and SQL Task), but now I need to add a data transform in there. ... Execute the transform after each loop step? ... You should loop with one transform task from Excel to SQL Server and import each file one after the other. ...
(microsoft.public.sqlserver.dts)
Re: Oh, where to start??? Reformatting HELP
... Thanks for the response David, ... the program that I intend to use only supports up to 10 back-references and I need more than that to do transform the data entirely in that one program. ... I was hoping to use Excel to do the first half of the formatting and ... ... Cells b2, b3, b4, etc are the policy numbers for the jobs in column a ...
(microsoft.public.excel.misc)
Re: Duplicate values in crosstab report
... your datasheet looks ok but not when it gets transfered to Excel? ... TRANSFORM Val,0)) AS ... > FROM BudgetAmtByCategory ... >> MS Access MVP ...
(microsoft.public.access.reports)
Re: adapting the findnext function
... > in via a lookup, is there anyway to make excel think they are just there ... > chrisrowe_cr's Profile: ... Prev by Date: ...
(microsoft.public.excel.programming)