Time align New Product Launches

[Guest]

Hello. I have 150 weeks of data across my page and many rows containing
products. My cells contain $ sales. The products sales start at different
points because they were launched at different times over the 150 weeks. I
would like to align every products sales so that their 1st weeks sales all
line up under each other and the same for week 2 etc so that I can compare
sales for each product launch. Can anyone please help? Thank you.

 

[Bob Phillips]

An example of what the data looks like and what you want it to look like
worild help. Make sure you clearly show empty cells.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Hello Bob. Where can I send the sample output? Thank you.

 

[Bob Phillips]

Lay it out in a post here.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Thanks for your offer. I have worked it out. Have a great day.