Transpose a variable number of columns to Rows

[CiskoWalt]

Hello,

I would appreciate it if someone would provide me with some code that will transpose a variable number of date columns to rows.

The first 7 columns in the attached file (the version that is 300 KB) will always contain the same type of data:

Column 1: Title
Column 2: Asset ID
Column 3: MSO
Column 4: MSO ID
Column 5: SD/HD
column 6: Network
Column 7: Content Type

Columns 8 and beyond will contain a date. When the user select 10 Days, there will be 10 date columns; when the user selects 90 days, there will be 90 columns of dates.

The attached file has on worksheet named Source and another named target. The Target worksheet contains a sample of how I would like to format the data.

Ideally, it the cell contains a value of Zero, then a row would not be inserted.


Thanks,

Walt