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
	Changing client.get() method type based on size of data...	dl0dth	1	735	Jan-02-2025, 08:30 PM Last Post: dl0dth
	Find a specific keyword after another keyword and change the output	sgtmcc	5	1,973	Oct-05-2023, 07:41 PM Last Post: deanhystad
	Convert File to Data URL	michaelnicol	3	2,768	Jul-08-2023, 11:35 AM Last Post: DeaD_EyE
	Grouping Data based on 30% bracket	purnima1	4	2,195	Mar-10-2023, 07:38 PM Last Post: deanhystad
	Extracting Data into Columns using pdfplumber	arvin	17	17,989	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	3,915	Dec-12-2022, 08:22 PM Last Post: jh67
	openpyxl convert data to float	jacklee26	13	12,499	Nov-19-2022, 11:59 AM Last Post: deanhystad
	conditionals based on data frame	mbrown009	1	1,591	Aug-12-2022, 08:18 AM Last Post: Larz60+
	I have written a program that outputs data based on GPS signal	kalle	1	2,092	Jul-22-2022, 12:10 AM Last Post: mcmxl22
	Convert nested sample json api data into csv in python	shantanu97	3	5,470	May-21-2022, 01:30 PM Last Post: deanhystad

Convert row data to columns based on keyword

User Panel Messages

Announcements