Help reworking data

[zour1el]

Hey all. I have a program that outputs the data in a fashion that makes it hard to use without the graphics, this in turn makes it hard to convert to a usable CSV. The fun thing is the headers for the data also does not always line up. I was wondering if you guys could help think of a way to reformat the data that can easily be used as a CSV.


Example Data of 2 transactions

Transaction
Name of the Store	Transaction Number:	Transaction#	Address of Location
State City,Zip	Date:	8/8/2018	Phone:	123-123-1234	Transaction Total:	$21.68
Tender	Account	Amount
CHARGE CARDS		$21.68
Total Tender:	$21.68
SKU	DCC	Description	Qty	Price	Discount	Tax	Ext Price
	10001998	60-03-01	ItemA	1	$20.00	$0.00	$1.68	$21.68
Subtotal:	$20.00
Transaction Discount:	$0.00	Total Tax:	$1.68	Transaction Total:	$21.68
Transaction
Name of the Store	Transaction Number:	Transaction#	Address of Location
State City,Zip	Date:	8/8/2018	Phone:	123-123-1234	Transaction Total:	$55.76
Tender	Account	Amount
CHARGE CARDS		$55.76
Total Tender:	$55.76
SKU	DCC	Description	Qty	Price	Discount	Tax	Ext Price
	10000076	30-10-01	Item1	1	$14.95	$0.00	$1.25	$16.20
	10003640	10-01-01	Item2	1	$23.50	$0.00	$1.97	$25.47
	10004418	10-01-01	Item3	1	$13.00	$0.00	$1.09	$14.09
Subtotal:	$51.45
Transaction Discount:	$0.00	Total Tax:	$4.31	Transaction Total:	$55.76

<tbody>
</tbody>

I would prefer something like this

Transaction Number:

Date:

Transaction Total:

Tender

Account

Amount

SKU

DCC

Description

Qty

Price

Discount

Tax

Ext Price

Subtotal:

Transaction Discount:

Total Tender:

RC1-00000014

8/3/2018

($1)

($1)

10001325

80-03-01

Old Spice Swagger 16oz

-1

($1.11)

$0.11

$0

($1)

($1.11)

$0.11

($1)

<tbody>
</tbody>