Arranging Data Below are sales data for a company that is highly seasonal around the Q4 holidays season. You are going t

[answerhappygod]

Arranging Data Below Are Sales Data For A Company That Is Highly Seasonal Around The Q4 Holidays Season You Are Going T 1 (100.29 KiB) Viewed 31 times

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 Quarter Key Revenues Q1 10 2018 2018 2018 Q2 15 Q3 32 2018 Q4 45 2019 10 2019 Q1 Q2 Q3 23 2019 33 Q4 71 2019 2020 Q1 19 2020 Q2 25 2020 Q3 42 2020 Q4 85 2021 Q1 20 2021 30 Q2 Q3 2021 65 2021 Q4 120