Convert row data to columns based on keyword

mjack24 · Feb-16-2019, 03:40 PM

I have two columns of data with string names and values (x, y). I would like to convert it to columns.

For example
Column 1 Column 2
String1 String 2
x1 y1
x2 y2
x3 y3

String1 String2
x1 y1
x2 y2
x3 y3

String1 String2
x1 y1
x2 y2
x3 y3

What is the best way to get this data into columns so that it can be graphed. String1 and String2 have the same names. Any help would be appreciated.

***micseydel*** · Feb-18-2019, 06:39 PM

What have you tried?

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Find a specific keyword after another keyword and change the output	sgtmcc	5	821	Oct-05-2023, 07:41 PM Last Post: deanhystad
	Convert File to Data URL	michaelnicol	3	1,170	Jul-08-2023, 11:35 AM Last Post: DeaD_EyE
	Grouping Data based on 30% bracket	purnima1	4	1,196	Mar-10-2023, 07:38 PM Last Post: deanhystad
	Extracting Data into Columns using pdfplumber	arvin	17	5,570	Dec-17-2022, 11:59 AM Last Post: arvin
	How to properly format rows and columns in excel data from parsed .txt blocks	jh67	7	1,880	Dec-12-2022, 08:22 PM Last Post: jh67
	openpyxl convert data to float	jacklee26	13	5,997	Nov-19-2022, 11:59 AM Last Post: deanhystad
	conditionals based on data frame	mbrown009	1	900	Aug-12-2022, 08:18 AM Last Post: Larz60+
	I have written a program that outputs data based on GPS signal	kalle	1	1,175	Jul-22-2022, 12:10 AM Last Post: mcmxl22
	Convert nested sample json api data into csv in python	shantanu97	3	2,838	May-21-2022, 01:30 PM Last Post: deanhystad
	Change elements of array based on position of input data	Cola_Reb	6	2,136	May-13-2022, 12:57 PM Last Post: Cola_Reb

Convert row data to columns based on keyword

User Panel Messages

Announcements