9 Item List=(3 Columns, 10 Rows) --> 1 Row (40 columns (blank in between the 10 items))

It's not very clear how your data is laid out, so please attach a sample workbook, with (manual) examples of how the data should appear when transposed.

Pete

Here is an example spreadsheet;
The two column list you'll see first is how i will at first see the data (2 columns)
I need to copy the data from the master sheet as found in column 1 and paste it to 1 Row, which is what you'll see next.EXCEL FORUM LIST TO 1 ROW.xls

I'm not sure I follow the logic of your "Derivatives", as there seems to be a gap in your examples. If you want the first record in cells A20 and B20 (for example), then the second record in E20:F20, and the 3rd record in I20:J20, and so on, then you can put this formula in A20:

=INDEX($A$2:$B$15,INT((COLUMNS($A:A)-0)/4)+1,1)

and this one in B20:

=INDEX($A$2:$B$15,INT((COLUMNS($A:B)-0)/4)+1,2)

(NOTE: the only difference is the number at the end of the formula, coloured red), and then you can copy that pair of formulae into E20:F20, I20:J20 etc.

Hope this helps.

Pete

The data that I am selecting are either derivatives or SE/TE Common Spec (publishing terms), and so once I have the list of data that I need to add to one of the lines of the spreadsheet, i am going to have to add the list of products (2 columns), and then add either DERIVATIVE or SE/TE Common Spec, and then a blank space before the next...
If its easier, I can just copy the ten items in the list, add the DERIVATIVE after it, then I have a 3 column list x 10 (or more) items, and I just need to turn it into a 1 row list, with a blank in between...
does that help?

Originally Posted by chriscovino

............If its easier, I can just copy the ten items in the list, add the DERIVATIVE after it, then I have a 3 column list x 10 (or more) items, and I just need to turn it into a 1 row list, with a blank in between...
does that help?

Or possibly a four "column" source list like this?

Row\Col	A	B	C	D	E
1
2	9780618804627*	HMM GA BLENDED USE PLAN GUIDE L2 07	DERIVATIVE	<blank>
3	9780618804795*	HMM GA EPUPIL EDTN ON CD-ROM LV2 07	DERIVATIVE	<blank>
4	9780618804856*	HMM GA ETCHER EDTN ON CD-ROM LV2 07	DERIVATIVE	<blank>
5	9780618813261*	HMM GA ONLN EPE 1YR SNGL USR LV2 07	DERIVATIVE	<blank>
6	9780618813551*	HMM GA ONLN EPE 6YR SNGL USR LV2 07	DERIVATIVE	<blank>
7	9780618813612*	HMM GA ONLN ETE 1YR SNGL USR LV2 07	DERIVATIVE	<blank>
8	9780618813674*	HMM GA ONLN ETE 6YR SNGL USR LV2 07	DERIVATIVE	<blank>
9	9780618896349*	HMM GA PERFORMANCE TASK GDE LV 2 07	DERIVATIVE	<blank>
10	9780618799961*	HMM GA UNIT RESOURCES BOOKLET L2 07	DERIVATIVE	<blank>
11	9780618804672*	HMM GEORGIA HOMEWORK BOOK LVL 2 07	DERIVATIVE	<blank>
12	9780618804733*	HMM GEORGIA PRACTICE BOOK LVL 2 07	DERIVATIVE	<blank>
13	9780618590322*	MATH GEORGIA PUPIL EDITION LVL 2 07	DERIVATIVE	<blank>
14	9780618590483*	MATH GEORGIA TE VOL 1 LEVEL 2 07	DERIVATIVE	<blank>
15	9780618590490*	MATH GEORGIA TE VOL 2 LEVEL 2 07	DERIVATIVE	<blank>
16

I could definitely create a list like that; Would it then be easy to turn that into a 1 row list?? Thank you in advance, as always!!

I will attempt it later this evening.

Thank you, Flame!! I've spent over five hours researching this today, and I am thinking that an OFFSET function might help?

Was able to get to it sooner than I expected.

Try this (I used A20) and fill across to BD20:

Formula:

Please Login or Register  to view this content.

It turns out that the fourth column of source data was not necessary. The formula generates a fortunate error every forth column/cell. I used IFERROR to turn that into the blanks separating each record.

I noticed you uploaded an XLS file. Your profile says Mac 2008. I am not familiar with Mac versions. Are there backwards compatibility considerations? If so the formula will need to be modified.

File is attached. Formula row highlighted.

I'm actually using Excel 2011 (Mac's Version of 2010)... I will try this in the morning; Thank you SOOOOOO much!

You're welcome. Look forward to your feedback.

Flame,
Seeing that this formula clearly worked in the example I provided, i decided to try to apply it to the current scenario I had... briefly, I have a Master Data sheet, and two more sheets- 1 where I will paste the list, and one where I'll enter the formula and get the result....
This: =IFERROR(INDEX($A$2:$C$15,CEILING(COLUMNS($A:A)/4,1),LOOKUP(COLUMNS($A:A),MOD(COLUMNS($A:A),4))),"")

turned into : =IFERROR(INDEX(Sheet2!A1:C44,CEILING(COLUMNS($A:A)/4,1),LOOKUP(COLUMNS($A:A),MOD(COLUMNS($A:A),4))),"")
and my result was... 9780618984954* DERIVATIVE 0 0 0 0 0 0 0 0 0 0 0 (I stopped dragging at this point)
I didn't get the 44 products like i was hoping; Did I do something wrong?

Try using absolute addressing in your first argument in INDEX. That range needs to be "anchored" or the formula will start referencing a different range as you drag across. This Sheet2!$A$1:$C$44 and not this Sheet2!A1:C44