LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 5
Default Transpose multiple groups of columns to multiple rowsrow

I have on 1 row:

Date, Author, URL, Book1, URL1, Sales1, Book2, URL2, Sales2, Book3, URL3, Sales3.

And repeat.

I would like:

Date, Author, URL, Book1, URL1, Sales1,
Date, Author, URL, Book2, URL2, Sales2,
Date, Author, URL, Book3, URL3, Sales3,

Thank you for your help.
 
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
Transpose multiple Columns to rows Michelle Excel Worksheet Functions 8 March 5th 10 10:55 PM
Transpose multiple columns [email protected] Excel Discussion (Misc queries) 3 April 17th 08 09:00 PM
Transpose multiple columns, functions Nancy Excel Worksheet Functions 6 April 14th 08 11:48 PM
I need a macro to transpose multiple columns A1-Z1, A2-X2 etc Wombat62 Excel Discussion (Misc queries) 7 September 18th 06 05:05 AM
repeated transpose from rows to columns with unequal groups kraymond Excel Discussion (Misc queries) 3 December 20th 04 02:39 PM


All times are GMT +1. The time now is 10:31 AM.

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

About Us

"It's about Microsoft Excel"