Arranging Data Below are sales data for a company that is highly seasonal around the Q4 holidays season. You are going to create a unique "Key" for each year/quarter so that you can use reference functions (VLOOKUP) to pull the data into the required format. In the yellow cells below create a key that concatenates the 'Year' and the 'Quarter". You may have to assemble data that needs to be addressed by the combination of two or more paramaters. Using reference functions and concatinating two (or even more) paramaters will easily permit you to do this. Concatination is presented in the 'EXCEL Complex Functions' Sheet of Cash Flow Statement (Workbook 6). As a reminder, concatination combines two or more text strings into a single text string. You can do it either with the CONCATINATE function of by using an "&". In that Workbook, we indicated you can use this new text string to perform a lot of value-added data analyses including VLOOKUPS, etc. Year 2018 Quarter Q1 Key Revenues 10 2018 Q2 15 2018 Q3 32 2018 Q4 45 2019 Q1 10 2019 Q2 23 2019 Q3 33 2019 Q4 71 2020 Q1 19 2020 Q2 25 2020 Q3 42 2020 Q4 85 2021 Q1 20 2021 Q2 30 2021 Q3 65 2021 Q4 120