Convert sequential vertical data (rows) into horizontal data (columns)

[Jes]

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

[randreag · Accepted solution]

hi @Jes 

Here i attached an example that answers your questions

let me know if you have any more questions