Hello,
The attached sample file, entitled 'Year-Over-Year-3QSales', contains two worksheets, one is entitled 'YOY3QSALES' featuring year-over-year sales, per customer, with a new customer column preceding each years sales results; a 2nd sheet is entitled 'Ideal Arrangement', featuring the data as it would ideally appear.
How can I combine all the customers into one single column, such that each customer's three sets of sales will all appear on the same row, as per arrangement of data in the 'Ideal Arrangement' worksheet?
Bear in mind that although the first two columns in the 'YOY3QSALES' sheet contain the same number of entries, they each have a unique customer that is absent in the other.
Additionally, the third column lists 7 customers, instead of the 6 listed in each of the first two columns.
(The real file contains hundreds of entries, so arranging them one by one, as I did in this sample file, is simply not manageable.)
Please avoid macros in your response, as I'm not sure I would be able to install one properly.
Thank you in advance.
Bookmarks