PC Review


Reply
Thread Tools Rate Thread

Re: Need to reorganize - transpose columns to rows per article number

 
 
zvkmpw
Guest
Posts: n/a
 
      19th Aug 2012
On Thursday, August 16, 2012 1:16:18 PM UTC-7, toblju wrote:
> I have a list with five columns. Every row contains following data:
>
> Article Info 1 Info 2 Info 3 Info 4
> 500086 black blue white yellow
> 500087 black red blue green
>
> I would like it to look like this:
>
> Article Number Info
> 500086 1 black
> 500086 2 blue
> 500086 3 white
> 500086 4 yellow
> 500087 1 black
> 500087 2 red
> 500087 3 blue
> 500087 4 green


With the source date in Sheet1, put the following in Sheet2.

In A2
=INDEX(Sheet1!A:A,INT((ROW()+2)/4)+1)

In B2
=MOD(ROW()-2,4)+1

In C2
=INDEX(Sheet1!$B:$E,INT((ROW()+2)/4)+1,MOD(ROW()-2,4)+1)

Copy A2:C2 down as far as needed.

Put the column headers in row 1.

Hope this helps getting started.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to reorganize - transpose columns to rows per article number toblju Microsoft Excel Misc 1 16th Aug 2012 07:00 PM
Transpose columns to rows using first columns repeated. hn7155 Microsoft Excel Worksheet Functions 7 13th Feb 2009 12:50 AM
Transpose rows to columns with varying numbers of lines per record SerPetr Microsoft Excel Programming 1 5th Jan 2006 04:38 AM
Transpose rows to columns w/varying numbers of lines per record =?Utf-8?B?TUc=?= Microsoft Excel Worksheet Functions 8 11th Nov 2005 02:01 AM
Need more columns! How to exceed default limit for number of columns per worksheet sallyember Microsoft Excel Misc 1 17th May 2004 03:42 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:33 PM.