wickedchew wickedchew is offline

Senior Member

Location: Philippines

Posts: 161

Quote:

Originally Posted by Billy_McSkintos

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.

Pivot table?

__________________
Asobi Wa Owari Da

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us