I have a dataset that lists company name, stock ticker, stock price & currency in a vertical manner & combine the transformed result with another table that contains column headings.
Question 1: I'd like to convert the table so that it looks horizontal as seen below. I've tried using the Cross Tab & Summarize tool but was not able to get the result that I was looking for.
Before Transformation
| Apple | 1 |
| AAPL | 2 |
| 130.6 | 3 |
| USD | 4 |
| Google | 1 |
| GOOGL | 2 |
| 2116.44 | 3 |
| USD | 4 |
After Transformation
| 1 | 2 | 3 | 4 |
| Apple | AAPL | 130.6 | USD |
| Google | GOOGL | 2116.44 | USD |
Question 2: Once the table is converted in a horizontal manner, I am planning on appending the 'After Transformation' table to another table that contains the actual column headings. I have not tried this yet because I'm trying to resolve Q1 but if you have a different approach, please let me know.
Column Headings
| CompanyName | Ticker | Price | Currency |
