Help with cleaning Data and convert rows to column

msve

Hello,

I am very new to Alteryx and with the help of this wonderful community I was able to scrape data from website and get to below format. I tried using data cleansing tool to remove " " from my data but its also removing the decimal point. I also tried other solutions from the community to convert rows to columns but looks like I am missing something. I have attached my workflow.

To format

name	ticker	closePrice	closePricePrevWeek	closePrice52WeekHigh	closePrice52WeekLow
Libor Overnight	LIBORON	2.38813	2.38938	2.39413	1.69688
Libor 1 Week	LIBOR1W	2.42125	2.41238	2.423	1.73875
Libor 1 Month	LIBOR1	2.49338	2.48975	2.52238	1.8775
Libor 2 Month	LIBOR2	2.56188	2.56238	2.65288	1.99788
Libor 3 Month	LIBOR3	2.5955	2.60875	2.82375	2.30031
Libor 6 Month	LIBOR6	2.66913	2.673	2.90788	2.4524
Libor 1 Year	LIBORYR	2.73	2.74575	3.14413	2.66263

Web Scraping WSJ - WIP.yxmd

Thableaus

Hi @msve 

I will try to give you some hints:

- Removing quotes and backslashes - Formula Tool with ReplaceChar could help you with this task:

- Preparing rows to convert to columns:

Multii-Row formula is adding an ID of 1 (start of the row) every time "name" appears in your dataset.

Cross-Tab to bring rows to columns:

You need to group by your Row ID field previously created.

I hope this helps.

Cheers,