I have a spreadsheet that has a list of products in column A, with date ranges for sales in column B. The way it is now, products with multiple ranges are listed multiple times in column A, and each sale date range is in a separate row, like this:
Item 111 | Jan-Jun
Item 111 | Sep
Item 111 | Oct-Dec
Item 121 | Jan
Item 121 | Apr-Jun
etc.
Is there a formula I can use that will transpose the date ranges from rows to columns, on the condition that the data in column A is the same as in the above row? In other words, so it would look like this:
Item 111 | Jan-Jun | Sep | Oct-Dec
Item 111
Item 111
Item 121 | Jan | Apr-Jun
Item 121
I can use a macro if that's what would work best, but I would prefer a formula if there's an option for that because macros work very slowly on our computers. Thanks so much in advance for any help!
Item 111 | Jan-Jun
Item 111 | Sep
Item 111 | Oct-Dec
Item 121 | Jan
Item 121 | Apr-Jun
etc.
Is there a formula I can use that will transpose the date ranges from rows to columns, on the condition that the data in column A is the same as in the above row? In other words, so it would look like this:
Item 111 | Jan-Jun | Sep | Oct-Dec
Item 111
Item 111
Item 121 | Jan | Apr-Jun
Item 121
I can use a macro if that's what would work best, but I would prefer a formula if there's an option for that because macros work very slowly on our computers. Thanks so much in advance for any help!
