ExcelBanter - View Single Post - Transpose multiple groups of columns to multiple rowsrow

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.