Macro to Centralize Weeks & Sales Data in 1 Column

[Slowe89]

Hi,

I have a sales report that currently lists projects and related product coding in columns C-G and then each weeks sales are located in columns H and onwards. Please see attached. The actual data set is quite large with 3000+ products and over 180 weeks of sales data


I am looking to essentially pivot all of the weeks that are currently across multiple columns into one central columns, columns H in the attached example with the respective sales information contained in column I.

Any help to automate this would be greatly appreciated.

Thanks,
SeamusData Example.PNG

[daboho]

Good case,to night will be test

[jindon]

Try

Please Login or Register  to view this content.

[Richard Buttrey]

Hi and welcome to the forum,

Here's a macro that will work. It assumes your data starts in A1 on sheet1. Run the Transpose macro.

See attached.

Please Login or Register  to view this content.

[daboho]

slowe89 try this

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[daboho]

another Option

Please Login or Register  to view this content.

[Slowe89]

Hi this is brilliant , thanks a million for the help. Works perfectly