1. 
2. 

I solved it XD

6. Elena already imported data summarizing the performance of the asset management team on the Performance Summary worksheet but wants to display the data in the range G5:H8 of the Asset Management worksheet. She asks you to switch the rows and columns when you insert the data to fit in the range G5:18. Go to the Performance Summary worksheet. Copy the data in the range A1:D2, and then transpose the rows and columns as you paste the data on the Asset Management worksheet starting in cell G5. A B E G H Queries & Connections Queries Ballantyne Investments Connections 1 B 1 query 2 Asset Management Team 3 Ballantyne_Asset_Management Team 7 rows loaded erformance Summary ($ millior Years Experience from 12 NY 10 CA 10 3 4. Name Position Specialty 5 Jeff Frye Portfolio Manager Fund Administration 6 Theresa Gao Research Analyst Acquisition 7 Victor Lattimer Investment Business Development 8 Heather Montgomery Relationship Manager Asset Management 9 Claudia Garcia Sales Manager Technology 10 Frank Krause Research Analyst Investments 11 19 OH Raa86 5 MS umw NJ WI 20 21